| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to automatically insert blank lines in between non-blank lines
as subject, thanks.
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to automatically insert blank lines in between non-blank lines
Try something like the following. Change the StartRow and EndRow to the
appropriate values. Sub AAA() Dim Ndx As Long Dim StartRow As Long Dim EndRow As Long StartRow = 1 '<<< CHANGE EndRow = 10 '<<< CHANGE For Ndx = EndRow To StartRow Step -1 Rows(Ndx).Insert Next Ndx End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message ... as subject, thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to automatically insert blank lines in between non-blank lines
lots of thanks.
"Chip Pearson" ¼¶¼g©ó¶l¥ó·s»D ... Try something like the following. Change the StartRow and EndRow to the appropriate values. Sub AAA() Dim Ndx As Long Dim StartRow As Long Dim EndRow As Long StartRow = 1 '<<< CHANGE EndRow = 10 '<<< CHANGE For Ndx = EndRow To StartRow Step -1 Rows(Ndx).Insert Next Ndx End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message ... as subject, thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically insert lines | Excel Worksheet Functions | |||
| Auto insert of blank lines | Excel Discussion (Misc queries) | |||
| macro to insert blank line when lines sum to zero | Excel Discussion (Misc queries) | |||
| Macro not recognizing blank lines as blank | Excel Discussion (Misc queries) | |||
| Macro to insert blank lines | Excel Discussion (Misc queries) | |||
Linear Mode
