Thread: Creating dymnamic named ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gromit Gromit is offline
external usenet poster
  
Posts: 1
Default Creating dymnamic named ranges

oops, slight typo in the previous response

=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet!$A:$A)-1)


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
Reply With QuoteReply With Quote