Thread: How to create a range address with ADDRESS function?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve McLeod Steve McLeod is offline
external usenet poster
  
Posts: 6
Default How to create a range address with ADDRESS function?
I can use this formula, =INDIRECT(ADDRESS(10,2)), but I haven't figured out
how to specify a range as in =INDIRECT(ADDRESS(10,2) & ":" & ADDRESS(30,6)).
I can put the range address into a cell and then reference the cell with
INDIRECT, but it would be nice to imbed the range address calculation inside
the INDIRECT function and save the step.
--
Pictou
Reply With QuoteReply With Quote