Cell reference

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. :)
 
D

Don Guillett

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
 
Top