Thread: Can A Named Range Be A Variable?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Minitman[_2_] Minitman[_2_] is offline
external usenet poster
  
Posts: 7
Default Can A Named Range Be A Variable?
Greetings,

I have a formula that is looking at a named range (Sheet1!A1) from
Sheet2. I need to add 19 more sheets (Sheet3 thu Sheet21). Is there
anyway to change which named range that formula is looking at?

TIA

-Minitman
Reply With QuoteReply With Quote