LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF FUnctions that produce TEXT results Jafferi[_2_] Excel Worksheet Functions 3 April 20th 09 04:32 AM
Parseing to produce text only Mick Barry Excel Worksheet Functions 5 October 17th 07 07:19 AM
can excel produce text in a given cell as a result of a boolean operation? Richard Erlacher Excel Discussion (Misc queries) 5 October 26th 06 09:39 PM
produce a formulate to produce assigned seats for dinner DavidJoss Excel Worksheet Functions 0 October 4th 05 02:29 AM
need some help combining a variable Gary Keramidas[_2_] Excel Programming 7 July 5th 05 02:51 PM


All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"