Can't get VBA code to do task at worksheet level not workbook level

Hello,

Sorry for the unusual subject title, it's hard to know how to put this in words!

I have the below code in my macro...

Please Login or Register  to view this content.

Currently when I run this macro it applies it to the whole workbook, whereas I actually want it to apply to the active worksheet only. I've tried

Please Login or Register  to view this content.

but this doesn't work.
Anybody know how to do this? Sorry if it's actually really easy - I'm entirely self-taught (well, excelforum-taught) so I often miss the easy things!!

Many thanks

If the names are defined at workbook level, but you only want the ones located on the sheet, then:

Please Login or Register  to view this content.

Romperstomper

very well done!!