vba to delete rows

  • Thread starter Thread starter ericahughes
  • Start date Start date
E

ericahughes

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!
 
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
 
Back
Top