Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple blank lines, between multiple lines
Title sounds silly doesnt it? I was wondering how i could format a column to insert 3 rows betwee each row. as if it were going from option1 option2 option3 to option1 option2 option3 and so on... I'm pretty sure that it has something to do with Selection.Insert Shift:=xlDown and Rows(":").Select but i don't know enough about excel programming to make th association. I hope you guys can help!! -- Wishmaste ----------------------------------------------------------------------- Wishmaster's Profile: http://www.excelforum.com/member.php...fo&userid=1561 View this thread: http://www.excelforum.com/showthread.php?threadid=27160 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple blank lines, between multiple lines
Sub AddRows()
Dim rng as Range, i as Long set rng = cells(rows.count,1).End(xlup) for i = rng.row to 2 step -1 cells(i,1).Resize(,3).EntireRow.Insert Next End Sub -- Regards, Tom Ogilvy "Wishmaster" wrote in message ... Title sounds silly doesnt it? I was wondering how i could format a column to insert 3 rows between each row. as if it were going from option1 option2 option3 to option1 option2 option3 and so on... I'm pretty sure that it has something to do with Selection.Insert Shift:=xlDown and Rows(":").Select but i don't know enough about excel programming to make the association. I hope you guys can help!!! -- Wishmaster ------------------------------------------------------------------------ Wishmaster's Profile: http://www.excelforum.com/member.php...o&userid=15614 View this thread: http://www.excelforum.com/showthread...hreadid=271601 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Worksheets, multiple lines and summarizing into one works | New Users to Excel | |||
In Excel 2007 chart with multiple lines, mouse doesn't track lines | Charts and Charting in Excel | |||
display 1 line of multiple worksheets into multiple lines on 1 wks | Excel Worksheet Functions | |||
Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
how to automatically insert blank lines in between non-blank lines | Excel Programming |