Deleting Rows
 

Does anyone have any suggestions for a code that will look at column A
and if any cell is blank in column A then delete the entire row?

Any help would be greatly appreciated.

Thanks!


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=491829

Deleting Rows
 

on error resume next
activesheet.range("a:a").cells.specialcells(xlcell typeblanks).entirerow.delete
on error goto 0

STEVEB wrote:

Does anyone have any suggestions for a code that will look at column A
and if any cell is blank in column A then delete the entire row?

Any help would be greatly appreciated.

Thanks!

--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=491829

--

Dave Peterson

Deleting Rows
 

Thanks Dave!

That worked perfect!!

--
STEVE
-----------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...nfo&userid=187
View this thread: http://www.excelforum.com/showthread.php?threadid=49182

Deleting Rows
 

Sub DeleteRows()
On Error Resume Next
columns(1).Specialcells(xlBlanks).EntireRow.Delete
End sub

--
Regards,
Tom Ogilvy


"STEVEB" wrote in
message ...

Does anyone have any suggestions for a code that will look at column A
and if any cell is blank in column A then delete the entire row?

Any help would be greatly appreciated.

Thanks!


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile:
http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=491829

Deleting Rows
 

Thanks Tom,

I appreciate your hel

--
STEVE
-----------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...nfo&userid=187
View this thread: http://www.excelforum.com/showthread.php?threadid=49182