Date in cell via VBA

[ad9051]

I was wondering how do i put the date into a cell via macro =now() would give "20/02/2012 11:45:35" where as i would simply like "20/02/2012"

Many thanks

Alan

[TMS]

Try using Date in the macro rather than Now


Regards, TMS

[TMS]

Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save