Sheet Header with Current Date

[PMARI]

Hi Friends,

I am having a workbook called 'Daily Report'. Consists 10 worksheets, Namely 'order, Dispatch & Pending & .......'

In each sheet having a table with heading in the first row like " Orders booked as on " Current Date".

Is there any macro to change only the date ( Text remains unchanged) when run the macro.

Kindly look suggests. thanks in advance.

 

[VoG]

Why not use a formula?

="Orders booked as on " & TEXT(TODAY(),"dd/mm/yyyy")

 

[PMARI]

Hi VoG,

Thanks for response. At present ,opening the sheet and changing the Date manually. Macro with this formula can serve the purpose. i will try and revert.