ToseSenpai
New Member
- Joined
- Apr 18, 2021
- Messages
- 29
- Office Version
- 365
- Platform
- Windows
Hi all,
If i have this code:
How can i change the part "Format(Now, "dd-mm-yy")" instead to give the date of today, give me a date in a determinate cell of the "sheet1"
For example:
Thank you all for your help!
If i have this code:
VBA Code:
TempFileName = "File name with date: " & Format(Now, "dd-mm-yy")
How can i change the part "Format(Now, "dd-mm-yy")" instead to give the date of today, give me a date in a determinate cell of the "sheet1"
For example:
VBA Code:
TempFileName = "File name with date: " & Range("A3")
Thank you all for your help!