View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Indirect Alternatives


Using XL 2007 - with 2003 compatibility

the below equation works (where Model_Info!$E$25 is truly the only "variable")

=INDIRECT(Model_info!$E$25&"!R"&ROW()&"C"&COLUMN() ,FALSE)

The workbook has multiple assumption pages based on dates. The user selects
a date and the workbook accesses the correct sheet.

I have many of these - what options do I have if I don't want to use
indirect and to insure that I'm grabbing the right cell.