|
|
#2
04-01-2014, 06:11 PM
|
||||
|
||||
You could use a macro like:
Code:
Sub DeleteBlanks()
Dim lRow As Long
With ThisWorkbook.ActiveSheet.UsedRange
lRow = .Cells.SpecialCells(xlCellTypeLastCell).Row
.Range("A1:A" & lRow).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End With
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Why cant I delete the black line at the side of my orginisational chart?
|
Gabby1991 | Drawing and Graphics | 1 | 01-07-2014 09:14 PM |
| unable to delete a horizontal line | jerryny | Word | 2 | 03-31-2013 05:59 PM |
|
Search for text then delete line
|
konopca | Word VBA | 2 | 06-07-2012 02:44 AM |
|
Very Urgent - Not able to delete Line
|
krishnaoptif | Drawing and Graphics | 11 | 05-29-2012 11:25 AM |
| Cannot delete line | adkr | Office | 1 | 04-07-2010 09:26 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode