Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert blank line macro
Can someone tell me how to write a macro that inserts a blank line between a
column of data? I have 100 lines of names and I want a blank line in between them all. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert blank line macro
laidebug, here is one way,
Sub insert_row() 'will insert a row between each row from A1:A100 Application.ScreenUpdating = False For i = 100 To 1 Step -1 Cells(i, "A").EntireRow.Insert Next i Application.ScreenUpdating = True End Sub -- 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 2002 & 2003 "laidebug" wrote in message ... Can someone tell me how to write a macro that inserts a blank line between a column of data? I have 100 lines of names and I want a blank line in between them all. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro To Insert Blank Row? | Excel Discussion (Misc queries) | |||
Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
Can I develop a macro to add blank rows to a list in Excel? | Excel Discussion (Misc queries) | |||
auto insert blank line | Excel Discussion (Misc queries) | |||
How do I insert a line into a footer? Enter doesn't work. | Excel Discussion (Misc queries) |