embedded enter key
 

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

Thanks,
Lee-An

--
lawndo
-----------------------------------------------------------------------
lawndog's Profile: http://www.excelforum.com/member.php...fo&userid=1430
View this thread: http://www.excelforum.com/showthread.php?threadid=26170

embedded enter key
 

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