View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
miserere miserere is offline
external usenet poster
 
Posts: 1
Default Selecting rows based simultaneously on 3 criteria


hi,
Is it possible to make a macro selecting/deleting rows of data based on
3 conditions placed in 3 columns (e.g. Col1=0 And Col2=0 And Col3<"").
I searched through the web for it but didn't find anything appropriate
and working.

I want to delete those rows but actually selection would do just fine.
I can't use autofiltering becouse of layout.

Thanks for any hint or code that would do the above.

Best Regards,
miserere :(


--
miserere
------------------------------------------------------------------------
miserere's Profile: http://www.excelforum.com/member.php...o&userid=27440
View this thread: http://www.excelforum.com/showthread...hreadid=469510