View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Selecting rows based simultaneously on 3 criteria

Oops. I didn't see Bernie's reply.

miserere wrote:

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


--

Dave Peterson