| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| delete empty rows between rows with text | Excel Discussion (Misc queries) | |||
Hybrid Mode
