vba to delete rows
 

Can anyone help me to write a vba to delete rows that have the word lab in
Column G? I would like to include nonptlab or labuseonly as well. Basically
anything that has the word lab in it. Thanks in advance!

vba to delete rows
 

Hi,

You may try this non VBA approach

1. Select the data in column G;
2. Press Ctr+F and type lab
3. Press Find all and then press Ctrl+A
4. This will select all the cells with lab in column G
5. Now Edit Delete Row

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ericahughes" wrote in message
...
Can anyone help me to write a vba to delete rows that have the word lab in
Column G? I would like to include nonptlab or labuseonly as well.
Basically
anything that has the word lab in it. Thanks in advance!