Thread: Defining a named range for a dynamic result set
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
GS GS is offline
external usenet poster
  
Posts: 364
Default Defining a named range for a dynamic result set
Hi Keith,

You might want to define the range as a dynamic range so when your code
changes its size, Excel adjusts for that automatically. You can get more info
he

http://www.contextures.com/xlNames01.html#Dynamic

HTH
Regards,
Garry
Reply With QuoteReply With Quote