Cell reference

  • Thread starter Thread starter Susie
  • Start date Start date
S

Susie

Hello All,

I am trying to write some code to select a certain cell.
I am getting an error when I try and use
"Range("A1").Select" but it lets me use:

Application.Goto Reference:="R1C1"

Why is this and can I use the other way. My excel is not
set to R1C1 style. I am using this code within a List
Box if that means anything.

Thanks in advance for your help. :)
 
There is no reason why either one of these won't work

Sub gotoa1()
Application.Goto Range("a1")
Range("a1").Select
End Sub

You can even use
Application.Goto Worksheets("sheet10").Range("a1")
instead of
worksheets("sheet10").select
range("a1").select
 
Back
Top