select row in sheet1, gather data, select sheet2 & paste gathered data.
Problem is how to update a cell in the active row of sheet1 without having to goback and select sheet1
Just update a cell in sheet1 whilst staying in sheet2
I tried
Sheets("newquick").Application.WorksheetFunction.ActiveCell.EntireRow.Cells(1, 71) = 1
but no luck
It would not be the same row in sheet1 all the time.
Can row number be used somehow?
Problem is how to update a cell in the active row of sheet1 without having to goback and select sheet1
Just update a cell in sheet1 whilst staying in sheet2
I tried
Sheets("newquick").Application.WorksheetFunction.ActiveCell.EntireRow.Cells(1, 71) = 1
but no luck
It would not be the same row in sheet1 all the time.
Can row number be used somehow?