View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?