Thread: Updating a Named range Automatically
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aidan.heritage@virgin.net is offline
external usenet poster
  
Posts: 244
Default Updating a Named range Automatically
Make the named range dynamic

eg

=A1:offset(a1,counta(a:a)-1,0)

would give you all records in column A

Reply With QuoteReply With Quote