Cell reference

[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.

 

[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

 

[Rob van Gelder]

That should work.

Have you got sheet protection or something going on?