Excel VBA: Created Named Range from cell.value

This:

Please Login or Register  to view this content.

could be this:

Please Login or Register  to view this content.

Otherwise, there's no point checking the cell value as the range will stop at the first blank cell anyway.

This:

Please Login or Register  to view this content.

Perhaps should be this:

Please Login or Register  to view this content.

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:

Formula:

Please Login or Register  to view this content.

based on a header in cell A1 and three rows of "data" is absolute.

Maybe try this to create Dynamic Named Ranges:

Please Login or Register  to view this content.

Regards, TMS