Using named range to clear cell data

Hi, long time reader first time poster.

Thanks for all your tips and help, this forum has been worth gold.

My question:

I have a defined range that contains data. Called Lvl_2

Column A contains a list of data. Column D may or may not contain data (some cells are blank). The data in Column D is populated by a VLOOKUP.

What I am trying to do is clear the contents of Contents of Column D if the value in the defined Range Lvl_2 is found in Column A.

I would like to be able to put this in a Module, there for I can recall the Sub when required.

Thanks for any help in advance.

Nuffers

if column D is populated via a vlookup, then couldnt you just use/modify/add to that vlookup to show nothing based on your crtaria, instead of using a macro?