Go to cell based on another cell

[davidathoegh]

Hi all,

I have been having trouble trying to figure this out.

Sheet1 L26 has a cell address which varies. I would like to go to this cell on Sheet2.

e.g. if the value of Sheet1 L26 = A4, I would like to select cell A4 on Sheet2.

I have attempted to use this code that I found online with little success

Sheets("Sheet1").Select
Range(Range("L26").Value).Select

Could someone point me in the right direction?

Many thanks,

Dave

 

[wigi]

Sheets("Sheet2").Select
Range(Sheets("Sheet1").Range("L26").Value).Select

But note that selecting is often unnecessary and only slows down the code execution.

 

[Andrew Poulsom]

Another way:

Application.Goto Reference:="Sheet2!" & Application.ConvertFormula(Range("L26").Value, xlA1, xlR1C1)

 

[niceguy_jay]

try this

Dim i As String
i = Sheets("Sheet1").Range("L26").Value
Sheets("sheet2").Range(i).Select

 

[davidathoegh]

Hi Wigi & Andrew

Thank you so much for your help & fast turnaround

Worked perfectly!