Thread: Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kjeldc Kjeldc is offline
external usenet poster
 
Posts: 33
Default Range

ActiveWorkbook.Names.Add Name:="Members", RefersToR1C1:="=Lists!R3C5:R12C5"

I have this in "Workbook_Open". But How do I expand the area if new members
are added