macro to insert lines
 

dear all,

I am looking for a way to have a macro shortcut copy a line and inser
it under the original with a few minor changes. The problem that I ru
in to is that the macro doesn't "float". so the inserted line is alway
somewhere in the top where I recorded the macro. :mad:

does anybody know how I can make the macro insert the line below th
selected line or cursor position?

Thanx in advance

--
hiryu
-----------------------------------------------------------------------
hiryuu's Profile: http://www.excelforum.com/member.php...fo&userid=2820
View this thread: http://www.excelforum.com/showthread.php?threadid=48183

macro to insert lines
 

As always, copy/paste your code here for comments.

--
Don Guillett
SalesAid Software

"hiryuu" wrote in
message ...

dear all,

I am looking for a way to have a macro shortcut copy a line and insert
it under the original with a few minor changes. The problem that I run
in to is that the macro doesn't "float". so the inserted line is always
somewhere in the top where I recorded the macro. :mad:

does anybody know how I can make the macro insert the line below the
selected line or cursor position?

Thanx in advance.


--
hiryuu
------------------------------------------------------------------------
hiryuu's Profile:
http://www.excelforum.com/member.php...o&userid=28206
View this thread: http://www.excelforum.com/showthread...hreadid=481831