macro to insert lines

[hiryuu]

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.

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

Thanx in advance.

[Don Guillett]

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

--
Don Guillett
SalesAid Software
[email protected]
"hiryuu" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
> 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
>