Remove All Defined Names

[pr4t3ek]

Hi,
I use Vlookup's a lot so i define my range with specific names a lot.
But when i want to clear the range names via Insert>Name>Define>"Select the range name then click delete. but instead of clicking on each range name, i would like to to delete all.

I can create a macro to do this but some days i use different range names that other days so the below will not work exactly..

Please Login or Register  to view this content.

but to keep in mind, i dont want it to remove the Print Area defined range.....

thanks!

[StephenR]

This appears to work:

Please Login or Register  to view this content.

[pr4t3ek]

awesome =]

had to use ActiveWorkbook instead of ThisWorkbook

nevertheless, thanks alot! =]