While I'm sure a macro can be built to do what you ask, have you looked
at AutoFilter? You can apply the filter to show only rows with blanks
in Col. K (or only non-blanks) which you can then delete enmasse or
copy to another area, etc.

Just a thought....


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=390143