This:
could be this:
Otherwise, there's no point checking the cell value as the range will stop at the first blank cell anyway.
This:
Perhaps should be this:
If not, if you have only a header but nothing below it, you will get a Named Range which will include the header and the first blank cell below it.
I'm not sure what you mean when you say:
Dynamic as named ranges are not absolute
The Named Ranges that you are creating are absolute. For example: based on a header in cell A1 and three rows of "data" is absolute.
Maybe try this to create Dynamic Named Ranges:
Regards, TMS
Bookmarks