send keys? 1

[faxof]

when in an excel cell i can press alt-enter to add a carriage return to the cell

how do i do that in code?

shold i use send keys or Chr(x)?

quizzed
faxof

 

[GlennUK]

Well, if you want to insert text into a cell and embed a carriage return, in VBA code, then do something like this...

ActiveCell.FormulaR1C1 = "well" & Chr(10) & " hello"

Hope that's what you mean.

Cheers, Glenn.

 

[BlackburnKL]

You can also use the VBA enum "vbLf" (Visual Basic Line Feed) which may or may not be easier to remember than the Chr(10). Either one works great. BlackburnKL