Cell reference
 

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

Cell reference
 

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

--
Don Guillett
SalesAid Software

"Susie" wrote in message
...
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. :)

Cell reference
 

That should work.

Have you got sheet protection or something going on?



"Susie" wrote in message
...
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. :)