View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RNM RNM is offline
external usenet poster
 
Posts: 1
Default Dynamic variable Reference

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