View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VicWestVan VicWestVan is offline
external usenet poster
 
Posts: 10
Default Combining Text to Produce a Variable Name

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.