Dynamic Named Rages

Giganews Newsgroups
Subject: Dynamic Named Rages
Posted by:  Dave Watkins (dwatki…@NOSPAM.insite.co.nz)
Date: Tue, 21 Oct 2003

Hi

I'm trying to get multiple dynamic named ranges to work on the same
sheet with multiple chuncks of data decending down the page. I'd like
each range to stop when it hits an empty cell as they are my seperaters.

I've found out how to do normal dynamic named ranges with OFFSET but
that doesn't work if you have any data underneath it as the COUNTA
includes that in the range size. I'd like the range to stop when it hits
an empty cell/row so I can start me next range on the next row.

Is this even possible?

Thanks
Dave

Replies