Hi
try selecting the entire range before starting entering data

--
Regards
Frank Kabel
Frankfurt, Germany


lawndog wrote:
Is there any way that I can "embed" an enter key into a cell?
I am copying and pasting from several rows into a different
application. I need to be able to send to the application a return
after the 5th column and then it should continue to past the next row
of data in.
So rather than typing 100 rows of data into my application I can have
the user highlight, copy and paste into the application.

Thanks,
Lee-Ann