Alternative to SendKeys
 

Hi,
I'm writing some Access data into an Excel workbook. The
user wants some of the data to have a linebreak in a cell
(ALt-ENTER). I can simulate this using Sendkeys but
that's brutally slow and open to errors.

Any ideas how I can concatenate two pieces of text with
the equivalent of Alt-Enter between them? The code would
look something like:

objSheet.Cells(i, 5).Value = rst!Name & ????? & rst!
CashValue

Thanks for your help.

Garry

Alternative to SendKeys
 

Thanks for the prompt replies guys! I can't believe it
was that simple. I was looking for something much more
complicated. D'OH!

Garry