Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert a row, copy info from another row and autosize the row
I have a macro that will copy and paste one row to the current row
(the selected row). However I would like it to insert a row instead of copying over the current row. And I would like it to resize the row to a specified size. Your assistance is appeciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert a row, copy info from another row and autosize the row
Price, try adding this to your code
Selection.EntireRow.Insert ActiveCell.RowHeight = 20.25 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "Price" wrote in message om... I have a macro that will copy and paste one row to the current row (the selected row). However I would like it to insert a row instead of copying over the current row. And I would like it to resize the row to a specified size. Your assistance is appeciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert a row, copy info from another row and autosize the row
gracias Paul!
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert a row, copy info from another row and autosize the row
Hi K. Price,
Even though your question was answered and you thanked Paul for the answer ... I have the feeling that you wanted to copy information to that empty row when you asked for.how to insert a row. In fact that is more clearly written in your subject. The subject should only reiterate what is asked for in a question. The question should be complete without having to look again at the subject. Take a look at Insert a Row using a Macro to maintain formulas http://www.mvps.org/dmcritchie/excel/insrtrow.htm which may give you some additional material. I don't know how resize fits into your plan, so you may be looking for a total or something else. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Price" wrote in message om... gracias Paul! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Macro- Insert rows based on dates and copy info from that row | Excel Discussion (Misc queries) | |||
Copy Insert Macro | Excel Discussion (Misc queries) | |||
Macro - Insert/Copy | Excel Discussion (Misc queries) | |||
Fit info into a no. of places (insert row, copy & paste) easily | Excel Worksheet Functions | |||
Copy and insert cell info macro help | Excel Discussion (Misc queries) |