Thread: Dynamic variable Reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
  
Posts: 863
Default Dynamic variable Reference

RangeName = "ABC" & Format$(n)

where n contains the number the user entered.

On Sat, 7 Aug 2004 20:15:48 -0500, RNM
wrote:

In VBA, how does one make a reference to a dynamic veraiable?

If I have named ranges "ABC1" thru "ABC9".
User enters "5" so I want to get the value of range "ABC5".
Without using Case statements.

Thanks,


---
Message posted from http://www.ExcelForum.com/

Reply With QuoteReply With Quote