Hello.
My sheet looks like this:
A B C D....

start Header
--- Text&Formulars
--- Text&Formulars
--- Text&Formulars
end
start Header
--- Text&Formulars
--- Text&Formulars
--- Text&Formulars
end

I wrote a makro which ads a new line&copies the Text&Formulars in th
new line. Works fine, but I'd like to change it to make it mor
comfortable:

When a cell between the lines "start" and "end" is selected the ne
line with Text&Formulars should always be added above "end". Afte
that, the first cell in the new line should be selected.

I played around with ".End(xlToRight)" but it seem's that's not th
right way...

Thank you for any help.
Stefa

--
skolle
-----------------------------------------------------------------------
skoller's Profile: http://www.excelforum.com/member.php...fo&userid=3238
View this thread: http://www.excelforum.com/showthread.php?threadid=52365