ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,279
- Office Version
- 2007
- Platform
- Windows
Hi.
In cell L13 i used to have =TODAY() but just noticed that somehow its no longer present.
Because of this the last 8 invoice have the dat 14/02/2023
I am looking to apply the date to the L13 cell using VBA so this dont happen again.
Would i be correct to write the code like this,pleae advise.
On the worksheet in question i dont know which sub to put it in.
Please advise the above two questions.
Thanks
In cell L13 i used to have =TODAY() but just noticed that somehow its no longer present.
Because of this the last 8 invoice have the dat 14/02/2023
I am looking to apply the date to the L13 cell using VBA so this dont happen again.
Would i be correct to write the code like this,pleae advise.
Rich (BB code):
Range("L13").NumberFormat = "mm/dd/yyyy"
On the worksheet in question i dont know which sub to put it in.
Please advise the above two questions.
Thanks