Clear cell with text in green color

[gibtoul]

Hello

I have in column A (A50: A200) of celulles with values ​​0 and numbers in green

Is it possible with VBA code to remove this range:

- The values ​​0
- And the numbers in green (Font.Color = vbGreen)

Thank you for your help

[Mumps1]

Hi gibtoul. Do you want to clear the cells that are both green and have the value 0 or do you want to clear the cells that are green or have a zero?

[gibtoul]

Hi Mumps1

Thank you for your return

I want to erase the celulles green or zero (0)

[Mumps1]

Try:

Please Login or Register  to view this content.

[gibtoul]

I tested the code

it clears out the values ​​0
values ​​but not green
to run the code, I make the following changes:

Please Login or Register  to view this content.

Thank you for your help

has soon

[Mumps1]

My pleasure.