Clearing cells with Command Button

[djp203]

Hi,

I know how to set up a command button (the easy bit) my problem is:

I have a row of cells which have information inside them, all of which I would like the formatting to remain the same and in one instance the numbers to reset to 0%.

So basically I want to clear cells A1, B1, C1, D1, E1 (to litteraly be blank) and have cells F1, G1, H1 to reset to 0% from what ever value was in them previously. The only problem may, or may no be, is that cells C1 and D1 are filled with Yes or No depending on the answer from a drop box.

Any help would be appreciated

 

[SteveO59L]

range("a1:h1").clearcontents

 

[djp203]

Hi Steve,

thanks for that - fantastic for clearing the cells so works in the first part, however with the cells which I wish to return to value 0% it completely clears the cells rather than returns them to 0%.......any ideas?

 

[SteveO59L]

Range("a1:e1").ClearContents
Range("f1:h1") = 0

 

[djp203]

Didn't realise it was that simple....

 

[SteveO59L]

Only simple, if you know how


If in doubt ....... ask


was always printed in big letters on drawings, when I was an apprentice.