Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. :) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |