Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i refer to cell contents in a macro?
I am a novice and i am trying to write a macro to position the sheet at a cell.
The cell reference that i want to go to is a variable which is the calculated content of another cell (CELL 2). How do i insert the CONTENTS of cell 2 (address I want to go to: i.e. R45) into the macro so it works properly? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i refer to cell contents in a macro?
Lets say A1 contains the formula
="Z" & ROW()*100 A1 displays: Z100 Then: Sub GoThere() Application.Goto reference:=Range(Range("A1").Value) End Sub -- Gary''s Student - gsnu200909 "Rob" wrote: I am a novice and i am trying to write a macro to position the sheet at a cell. The cell reference that i want to go to is a variable which is the calculated content of another cell (CELL 2). How do i insert the CONTENTS of cell 2 (address I want to go to: i.e. R45) into the macro so it works properly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use cell contents to refer to a sheetname in a formula | Excel Worksheet Functions | |||
Refer to a worksheet/name using cell contents? | Excel Worksheet Functions | |||
Refer in macro to cell | Excel Programming | |||
Contents of a cell refer to sheet name | Excel Programming | |||
Using contents of cell to refer to a worksheet | Excel Programming |