How to check if named range not refer to workbook's range?

**jaryszek** · 06-27-2019, 06:20 AM

Hi,

i want to detect if named range is not referred to workbook range directly:

Screenshot_16.png

in example you can see that named range was inputted via named manager and not refering to any worksheet.

How can i do this?
Jacek

**romperstomper** · 06-27-2019, 06:33 AM

You could probably just test the RefersToRange property of the name with an error handler.

**YasserKhalil** · 06-27-2019, 06:34 AM

Try

Please Login or Register  to view this content.

**jaryszek** · 06-27-2019, 06:38 AM

Hi Guys,

Rory - probably?

YasserKhalil - it will loop each time through each worksheet for each named range. i do not know if it will be fast method.

Jacek

**YasserKhalil** · 06-27-2019, 06:43 AM

Try this version

Please Login or Register  to view this content.

**jaryszek** · 06-27-2019, 06:44 AM

oo great solution Yasser,

thank you!
Jacek

**YasserKhalil** · 06-27-2019, 06:45 AM

You're welcome. Glad I can offer little help

**romperstomper** · 06-27-2019, 07:05 AM

"probably" translates roughly to "I don't have time to test this and, given the nature of VBA there are probably exceptions, but, in theory,"

How to check if named range not refer to workbook's range?

LinkBack

Thread Tools

Rate This Thread

Display

How to check if named range not refer to workbook's range?

Re: How to check if named range not refer to workbook's range?

Re: How to check if named range not refer to workbook's range?

Re: How to check if named range not refer to workbook's range?

Re: How to check if named range not refer to workbook's range?

Re: How to check if named range not refer to workbook's range?

Re: How to check if named range not refer to workbook's range?

Re: How to check if named range not refer to workbook's range?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] refer from worksheet_change event to workbook named range

[SOLVED] Refer to named range in different, closed workbook

refer to range within named range

Refer to a Workbook level named range

[SOLVED] What happens when I refer to a named range?

VBA Refer to named range in different workbook

[SOLVED] named range ?::how to I refer to current workbook without using its name?

Bookmarks

Bookmarks

Posting Permissions