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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable in application line
Dim rngTemp As Range
Set rngTemp = Sheets("Sheet2").Range("A1") Application.Goto Reference:=rngTemp If this post helps click Yes --------------- Jacob Skaria "Nev" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable in application line
Jacob
Thanks for the quick reply. Sorry - I want to use whatever is in "Info F30" as the variable. Therefore if "Info F30" said May it would take me to worksheet "May", Sept to worksheet "September" etc Thanks nev "Jacob Skaria" wrote: Dim rngTemp As Range Set rngTemp = Sheets("Sheet2").Range("A1") Application.Goto Reference:=rngTemp If this post helps click Yes --------------- Jacob Skaria "Nev" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable in application line
Dim strSheet as String
strSheet = Sheets("info").Range("F30") Sheets(strSheet).Activate OR Dim strSheet as String strSheet = Sheets("info").Range("F30") Application.Goto Reference:=Sheets(strSheet).Range("A1") -- If this post helps click Yes --------------- Jacob Skaria "Nev" wrote: Jacob Thanks for the quick reply. Sorry - I want to use whatever is in "Info F30" as the variable. Therefore if "Info F30" said May it would take me to worksheet "May", Sept to worksheet "September" etc Thanks nev "Jacob Skaria" wrote: Dim rngTemp As Range Set rngTemp = Sheets("Sheet2").Range("A1") Application.Goto Reference:=rngTemp If this post helps click Yes --------------- Jacob Skaria "Nev" wrote: 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 |
Reply |
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 |