Thread: dynamic ranges getting invalidated
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kieran[_47_] Kieran[_47_] is offline
external usenet poster
  
Posts: 1
Default dynamic ranges getting invalidated
Hi,

this is untested, and seems a strange workaround but try
StockSymbol
=OFFSET(indirect("Main!$A$10",0,0,COUNTA(indirect( "Main!$A$10:$A$35"),1)


HI

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote