Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting rows with the same criteria | Excel Worksheet Functions | |||
Selecting Rows that meet criteria | Excel Worksheet Functions | |||
Selecting rows based on criteria | Excel Discussion (Misc queries) | |||
VBA - Selecting Based on Criteria | Excel Programming | |||
Selecting Sheets based on Cell Criteria. | Excel Programming |