Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert lines
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to insert lines | Excel Worksheet Functions | |||
macro to insert lines for 3 sections | Excel Discussion (Misc queries) | |||
macro to insert lines | Excel Programming | |||
Macro to insert blank lines | Excel Discussion (Misc queries) | |||
Macro insert lines | Excel Discussion (Misc queries) |