I have a macro that will insert my selected lines underneath the las
entry. However, I can only get it to do this once, and in the sam
spot. How can I get it to keep adding lines after each entry if th
user needed to?
For example if I pressed the command button once, it would enter th
new set of lines and renumber it. If I wanted to enter more line
after this entry, I would press the button again and it would enter th
new blank lines and renumber in sequence. This is the macro
recorded.
Rows("10:12").Select
Selection.Copy
Range("A19").Select
ActiveSheet.Paste
Range("B16:B18").Select
Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("B16:B21")
Type:=xlFillDefault
Range("B16:B21").Select
Can anyone help me out?
Thanks
--
tanyhar
-----------------------------------------------------------------------
tanyhart's Profile:
http://www.excelforum.com/member.php...fo&userid=3514
View this thread:
http://www.excelforum.com/showthread.php?threadid=54950