macro which looks in column and if it is blank deletes entire row

[vikram]

macro which looks in column and if it is blank deletes entire row


if sny row in column A is blank , macro deletes entire row

thanks
appreciate u al

 

[Don Guillett]

Since this is very often asked question, it might be a good time to use the
archives or Ron's excellent add in
http://www.rondebruin.nl/

 

[DNF Karran]

sub
dim currange as range
for each currange in range"A:A"
if currange.value = empty then currange.entirerow.delete
next
end sub

Untested as i have typed it straight into the editor....

Dunca

 

[Earl Kiosterud]

vikram,

There's code to do this at www.cpearson.com.