This is getting close but how the code know what name to call the offset
Barb Reinhardt wrote:
When you set up the named range you could do something like this:

=offset(Sheet1!$A$1,0,0,counta($A:$A),counta($1:$ 1))

It will dynamically expand and contract as needed. Let me know if that's
what you need.

Using This Workbook module, I need to set up Name Ranges everytime the Work
Book is Open but the size of the range may change between each opening and
[quoted text clipped - 12 lines]

Thanks

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