Range("A1,C1,E1,G1") = Date()

If this post helps click Yes
---------------
Jacob Skaria


"Neil Holden" wrote:

I have a button that basically approves jobs, i need a line of code that when
pressed will automatically insert the current date into 4 separate cells
within the excel sheet.

Thanks.