ExcelNoob222
Board Regular
- Joined
- Jun 17, 2020
- Messages
- 77
- Office Version
- 365
- Platform
- Windows
Hi,
I have the below VBA:
Range("A1").Formula = "=""Last Updated: ""&TEXT(NOW(),""mm/dd/yyyy hh:mm"")&"" Current week: ""&Tracking!K2"
which gives me the following "Last Updated: 05/25/2022 10:05 Current week: 2"
I want it to look like this though:
"Last Updated: 05/25/2022 10:05
Current week: 2"
I have tried the below codes but i get a #name? error.
Range("A1").Formula = "=""Last Updated: ""&TEXT(NOW(),""mm/dd/yyyy hh:mm"")& CHR(10) &"" Current week: ""&Tracking!K2"
Range("A1").Formula = "=""Last Updated: ""&TEXT(NOW(),""mm/dd/yyyy hh:mm"")& CHR(13) &"" Current week: ""&Tracking!K2"
Range("A1").Formula = "=""Last Updated: ""&TEXT(NOW(),""mm/dd/yyyy hh:mm"")& vbLf &"" Current week: ""&Tracking!K2"
Any ideas? Thanks!
I have the below VBA:
Range("A1").Formula = "=""Last Updated: ""&TEXT(NOW(),""mm/dd/yyyy hh:mm"")&"" Current week: ""&Tracking!K2"
which gives me the following "Last Updated: 05/25/2022 10:05 Current week: 2"
I want it to look like this though:
"Last Updated: 05/25/2022 10:05
Current week: 2"
I have tried the below codes but i get a #name? error.
Range("A1").Formula = "=""Last Updated: ""&TEXT(NOW(),""mm/dd/yyyy hh:mm"")& CHR(10) &"" Current week: ""&Tracking!K2"
Range("A1").Formula = "=""Last Updated: ""&TEXT(NOW(),""mm/dd/yyyy hh:mm"")& CHR(13) &"" Current week: ""&Tracking!K2"
Range("A1").Formula = "=""Last Updated: ""&TEXT(NOW(),""mm/dd/yyyy hh:mm"")& vbLf &"" Current week: ""&Tracking!K2"
Any ideas? Thanks!