Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable in application line
I use the line below in part of my spreadsheets.
Application.Goto Reference:=Range("'addresses'" & "!a1") Range("B7").Select I would like to use this elsewhere where 'addresses' is a variable ie It would pick up whatever is in sheet "info" F30 and take me to the relevant sheet How can I do this? thanks Nev |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code to run & wait for cmd line interface application | Excel Programming | |||
Application.Run with variable number of arguments | Excel Programming | |||
Excel Application Level Global Variable | Excel Programming | |||
How to Reference Global Variable for external application. | Excel Programming | |||
application.Value(Variable) | Excel Programming |