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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert lines
I'm not quite sure what you are asking, but I think this will at least help. For now I filled cells A1:A20 with the numbers 0-20. I then added this line to your macro: Range("A1").End(xlDown).Select So your new macro looks like this: Sub Bleh() Rows("10:12").Select Selection.Copy Range("A1").End(xlDown).Select ActiveSheet.Paste Range("B16:B18").Select Application.CutCopyMode = False Selection.AutoFill Destination:=Range("B16:B21"), Type:=xlFillDefault Range("B16:B21").Select End Sub If that's not what you're looking for, I think it will at least give you a good start finding it. -- mkerstei ------------------------------------------------------------------------ mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688 View this thread: http://www.excelforum.com/showthread...hreadid=549504 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert lines
If you look at the example I have in a Word file, the 3 rows that star with "Task #13" are the ones that were inserted with the macro create above. What I would like to do now, is be able to enable the user to hit tha button again and have more rows inserted below Task #13 that would be continuation for Task #14, #15, and so forth. It would be dependen upon how many tasks each estimate needs, so there would never be an set number of additions to the tasks. Is the able to be done +------------------------------------------------------------------- |Filename: Example.doc |Download: http://www.excelforum.com/attachment.php?postid=4864 +------------------------------------------------------------------- -- tanyhar ----------------------------------------------------------------------- tanyhart's Profile: http://www.excelforum.com/member.php...fo&userid=3514 View this thread: http://www.excelforum.com/showthread.php?threadid=54950 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert lines
In the ms ng I do not see these php files.
-- Don Guillett SalesAid Software "tanyhart" wrote in message ... If you look at the example I have in a Word file, the 3 rows that start with "Task #13" are the ones that were inserted with the macro created above. What I would like to do now, is be able to enable the user to hit that button again and have more rows inserted below Task #13 that would be a continuation for Task #14, #15, and so forth. It would be dependent upon how many tasks each estimate needs, so there would never be any set number of additions to the tasks. Is the able to be done? +-------------------------------------------------------------------+ |Filename: Example.doc | |Download: http://www.excelforum.com/attachment.php?postid=4864 | +-------------------------------------------------------------------+ -- tanyhart ------------------------------------------------------------------------ tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148 View this thread: http://www.excelforum.com/showthread...hreadid=549504 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert lines
Sorry, I have no clue what your message meant. In the word file is picture of what the spreadsheet looks like -- tanyhar ----------------------------------------------------------------------- tanyhart's Profile: http://www.excelforum.com/member.php...fo&userid=3514 View this thread: http://www.excelforum.com/showthread.php?threadid=54950 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert lines
Sorry, I have no clue what is in your attachment since we don't get the
attachments in this ng. Perhaps you should try copy\paste and clear explanations if you desire help here. -- Don Guillett SalesAid Software "tanyhart" wrote in message ... Sorry, I have no clue what your message meant. In the word file is a picture of what the spreadsheet looks like. -- tanyhart ------------------------------------------------------------------------ tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148 View this thread: http://www.excelforum.com/showthread...hreadid=549504 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert lines
I figured it out. Thank -- tanyhar ----------------------------------------------------------------------- tanyhart's Profile: http://www.excelforum.com/member.php...fo&userid=3514 View this thread: http://www.excelforum.com/showthread.php?threadid=54950 |
Reply |
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) |