ExcelBanter - How can I double-space in an Excel cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How can I double-space in an Excel cell? (https://www.excelbanter.com/excel-programming/310073-re-how-can-i-double-space-excel-cell.html)

Tom Ogilvy

How can I double-space in an Excel cell?

where you want a return, do Alt+Enter and continue typing

abcd alt+enter efgh

produces

abcd
efgh

in code
activeCell.value = "abcd" & chr(10) & "efgh"

--
Regards,
Tom Ogilvy

"metcalfinated" wrote in message
...
How can I double-space in an Excel cell?

All times are GMT +1. The time now is 07:07 AM.