Printing then clearing a cell

[tonylpcs@yahoo.co.uk]

Hi Everyone,

Can someone please give me the code i would need to get a macro to print a page then clear cell K2?

thanks

Tony

 

[VoG]

Try

Sub prt()
ActiveSheet.PrintOut
Range("K2").ClearContents
End Sub

 

[tonylpcs@yahoo.co.uk]

Thank you,

I was so close! LOL

Tony