VBA to insert second line in cell

[ExcelNoob222]

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!

 

[Fluff]

It should be CHAR not CHR

 

[jkpieterse]

Chr(10) is correct, but you must format the cell and check the Wrap box on the alignment tab.
Sorry, please disregard this answer, it is nonsense

 

[ExcelNoob222]

It should be CHAR not CHR

Awesome, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.