How excel handles names in multiple sheets

Hi, I'm just wondering what this code will do when there are multiple sheets with the same named range. Will it delete them all? Just the first one?

Please Login or Register  to view this content.

Hello Dmartindale,

Named Ranges are a collection object. Each item in a collection must be uniquely identifiable. Only one range can exist with that name. Define a named range on a worksheet. On a different sheet, name a different range with the same name. The first range is now defined as the second range. You only delete a single range with your code.

Sincerely,
Leith Ross

Hm, thanks Leith, ok I'm certain that I have multiple named ranges with the same name, so they must be uniquely identifiable by their sheet name. Would it make sense to say the following?

Please Login or Register  to view this content.