| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Blank Lines
Hi...
I used to know how to do this. Can anyone remind me how to delete blank lines in spreadsheet and have all lines with data to shuffle together? Thanks in advance... Gordon... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete Blank Lines
I believe you are trying to do this:
Sub RemoveBlankLines() LR = Range("A65536").End(xlUp).row For myRow = LR to 1 Step - 1 if isEmpty(Range("A" & myRow)) then Rows(myRow).Delete End if next myRow "Gordon" wrote: Hi... I used to know how to do this. Can anyone remind me how to delete blank lines in spreadsheet and have all lines with data to shuffle together? Thanks in advance... Gordon... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete Blank lines in excel workbook? | Excel Discussion (Misc queries) | |||
| how to delete rows which is blank and which has ======== ( lines) | Excel Discussion (Misc queries) | |||
| Delete Blank Lines | Excel Discussion (Misc queries) | |||
| Delete Blank Lines | Excel Discussion (Misc queries) | |||
| Delete Blank Lines | Excel Discussion (Misc queries) | |||
![Gordon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
