Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have defined 2 variables AB01 and AB02 as follows:
Dim AB01, AB02 as Range and mapped them to row ranges using Set AB01 = Rows("1:100") Set AB02 = Rows("101:200") and wish to Select a row group depending on whether the Application.Caller.Name is "Picture 1" or "Picture 2"... something like the following (which is not correct but conveys what I'm trying to do): "AB"+Right(Application.Caller.Name,2).Select Any ideas on how to achieve the objective above. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF FUnctions that produce TEXT results | Excel Worksheet Functions | |||
Parseing to produce text only | Excel Worksheet Functions | |||
can excel produce text in a given cell as a result of a boolean operation? | Excel Discussion (Misc queries) | |||
produce a formulate to produce assigned seats for dinner | Excel Worksheet Functions | |||
need some help combining a variable | Excel Programming |