Hello

I have been trying to find a way to clear contents from a range of data.
The way it is set up is a range of 12Cx50R. Above that range each of the 12
columns has a cell with an If statement that says clear or save. I would
like a macro that could clear the contents of each row of the columns that
say clear in that range. Can anyone help?

Thanks!

For clarification, do you want to clear the contents for all fifty rows in
only the columns that that have clear in the formula row at the top of the
range? That is the condition that would make sense.

"WBTKbeezy" wrote:

Hello

I have been trying to find a way to clear contents from a range of data.
The way it is set up is a range of 12Cx50R. Above that range each of the 12
columns has a cell with an If statement that says clear or save. I would
like a macro that could clear the contents of each row of the columns that
say clear in that range. Can anyone help?

Thanks!