View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default named ranges get larger

have a look he

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


"thomas donino" wrote:

I have a sheet with a named range. every month i add a row of data via a
macro. How can I set the named range to also get one row larger?