Sub DeleteBlanks()
On Error Resume Next
Range("E1:E150").SpecialCells(xlCellTypeBlanks).En tireRow.Delete
(xlShiftUp)
End Sub

--
HTH...

Jim Thomlinson


"saziz" wrote:


Jim,
It worked prefectly, Thank you
How can I change it to delete rows instead of cells:
Range("f1:f2950")._SpecialCells_(xlCellTypeBlanks) .Delete (xlShiftUp)
^ I want to change this to delete rows


Syed


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=498504