What is the equivalent of 'Shift+Enter in a cell' in VBA?

  • Thread starter Thread starter Suh Suk Ho
  • Start date Start date
S

Suh Suk Ho

Dear Colleagues;

Isn't that vbCrLf?

I tried it but VBA doesn't seem to recognize it as that.

Thanks

Suh, Suk Ho
 
Dear Colleagues;

Isn't that vbCrLf?
Click to expand...

ActiveCell.FormulaR1C1 = "This is " & vbLf & "A New line"

The new line in a cell in Excel is the line feed (chr(10)) character
only, not carriage return + line feed.
 
Deear Colleagues;

Thank you very much for your kind enlightenment.

It worked like charm.

Kam-sa-hap-ni-da!!!

Suh, Suk Ho
 
Back
Top