View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Fredriksson via OfficeKB.com Fredriksson via OfficeKB.com is offline
external usenet poster
 
Posts: 51
Default Add a Dynamic Name Range

How would I delare CompanyData if I do not have a range define? How would
the program know Which Worksheet Columns and Rows to use.

Bob Phillips wrote:
Try this

ActiveWorkbook.Cells(CompanyData.Rows.Count + 1,
CompanyData.Columns.Count).Name="CompanyXrefRange "

Using This Workbook module, I need to set up Name Ranges everytime the
Work

[quoted text clipped - 16 lines]

Thanks


--
Message posted via http://www.officekb.com