Thread: how do I do a variable length array based on the value in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark Pranger
 
Posts: n/a
Default how do I do a variable length array based on the value in a cell
I want to create a cell range that will be based on the value of a cell so
that i can change the value of the cell and the range will lengthened or
shortened. Say I want to have the range start at cell b1 and go down the
column for 10 cells. then I decide to change it to 15 cells and then 40
cells. But I don't want to have to rewrite the formula each time. Any
suggestions?

Reply With QuoteReply With Quote