need a code to clear contents in a cell

[tonylpcs@yahoo.co.uk]

Hi Everyone,

Can someone give me a line of code to clear the contents of sheet1 A1 for me, and can you give me another code to clear both sheet1 A1 and C3 but without changing any of the other lines thanks

Tony

 

[VoG]

Try

Sub clr()
Sheets("Sheet1").Range("A1,C3").ClearContents
End Sub

 

[cb711]

Range("A1,C3").Select
Selection.ClearContents

 

[tonylpcs@yahoo.co.uk]

Superd once again !

your are a true genius!

Thanks for all your help

Tony