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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to count colored cells 1
Word VBA for deleting Selected Row 0
vba delete 2
VBA to automatically cut, paste entire row based on date input and delete row 0
Canoscan FS4000US IR/FARE Problem 1
Delete rows based on contents of Col A 0
macro shortcut help 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top