View range assigned to range name

[Marnhullman]

I have assigned a range name to the current range in VBA. How do I check that the range has been assigned correctly?

Thank you

[davesexcel]

Please Login or Register  to view this content.

The named range will be in the name dropdown

2021-02-14_9-11-10.jpg

[Marnhullman]

The name doesn't appear in the dropdown but I just added a couple of lines:

Set rngPayRange = Selection
rngPayRange.Select

Then I was able to see the highlighted range which confirmed the macro worked OK!

Thanks

[davesexcel]

That is not naming a range, you are setting a range variable.

[Marnhullman]

That is not naming a range, you are setting a range variable.

Thank you, yes I realise that now.