Deleting a row if it contains the right criteria

**TDN** · 11-19-2010, 01:13 AM

Hello,

I have a project that I'm working on and stuck at trying to figure this part out. It is in a larger database of information and I need a macro that will analyze one column of data and delete the entire row if it's value is under 30 sec.

Help!

**Simon Lloyd** · 11-19-2010, 01:40 AM

you dont say which column to look at so you can adjust this yourself!

Please Login or Register  to view this content.

**lakshithaw** · 11-19-2010, 02:55 AM

With this one you can do the action for any selection of yours...

Please Login or Register  to view this content.

**Simon Lloyd** · 11-19-2010, 03:39 AM

Originally Posted by lakshithaw

With this one you can do the action for any selection of yours...

Please Login or Register  to view this content.

You will have lots of problems if you choose to do it this way, firstly selecting or activating all the time will slow excel down and is not necessary, secondly you should always delete from the bottom up