Does anyone know if it's possible to set the active cell on one sheet as a variable so that it can be used to select the same cell on another sheet? So that if I select, say, C5 on Sheet1 and then run the macro it will automatically select Sheet2 and cell C5? Both cells would contain no data. I know I can do it if I have the cell reference typed into the cell:
However, I am unable to see how I can get it to work if the cell on Sheet1 is blank.
I'm sure it's simple but so am I so please help!
Code:
Dim i As String
i = ActiveCell
Sheets("Sheet2").Activate
Range(i).Select
However, I am unable to see how I can get it to work if the cell on Sheet1 is blank.
I'm sure it's simple but so am I so please help!