Add Date Over 8 Cells

Hi This is my first Post Please Be Gentle

I deal with order applications on a daily basis and find it frustrating to keep on adding the date Manually

I already have Macros on saving the document with a cell ref and in a specific location

I need to add a macro to assist in adding the current date into 8 cells with 1 Digit per Cell

Range is AB97:AI97

Ex: D(AB97) D(AC97) M(AD97) M(AE97) Y(AF97) Y(AG97) Y(AH97) Y(AI97)

Please help

===================================================================

Please Login or Register  to view this content.

Hi, welcome to the Forum.

Please post code in

Please Login or Register  to view this content.

Try something like this...

Please Login or Register  to view this content.