Clear contents from 1 cell only

[dave_w1967]

Hello to all the Gurus, Could anybody help me at all with this problem, I have created a form button and when I click on it, it will change the row to a Red Background which works well, what I'm trying to do is on that particular row only as soon as the row changes red the contents in a cell in column 'Z' clears but just for that cell in column 'Z' all the other cells in column 'Z' will be left untouched. I've tried various ways but cannot get the cell to clear unless I do a range to which I do not want. code as follows and forgive me i'm just learning. Thanks to all that can help.

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Thanks

Dave.W

[Fluff13]

How about

Please Login or Register  to view this content.

[dave_w1967]

Again works perfectly, (Fluff 13) thank you so much, your time is very much appreciated.

Best regards.

[Fluff13]

Glad to help & thanks for the feedback