Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a macro
I need to write a macro that will allow me to add any number of rows (as desired) BETWEEN each of the existing values in column A. Now when this is done, it must at the same time populate these new rows with with cell values above the inserted rows. So if A1 = Apples... and I add 5 rows,only the cells inserted in col A below A1 should take the value "Apples" until the next value Pears. Then the next 5 cells below Pears should have "Pears". Hope this is explained clearly. Thanx Roxio -- Roxio ------------------------------------------------------------------------ Roxio's Profile: http://www.excelforum.com/member.php...o&userid=28366 View this thread: http://www.excelforum.com/showthread...hreadid=479478 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro writing | Excel Worksheet Functions | |||
writing macro | Excel Programming | |||
help writing macro | Excel Programming | |||
VBA-writing a macro | Excel Programming | |||
Writing Macro | Excel Programming |