Escanaba
asked on
Excel VB To Delete Rows If Specific Text Is Found
Hello,
Can someone provide a code that looks at sheet2, starting at row 2, and if the text: Browser_type is found, the entire row is deleted? This will need to loop to the end of the worksheet until no data is found.
Thanks!
Can someone provide a code that looks at sheet2, starting at row 2, and if the text: Browser_type is found, the entire row is deleted? This will need to loop to the end of the worksheet until no data is found.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Escanaba,
A few questions, please...
(1) Roughly how long?
(2) Any formulas on the sheet? If so, changing Calculation to manual would definitely help!
(3) Roughly how many "Browser_type" entries do you have?
Thanks,
Brian.
A few questions, please...
(1) Roughly how long?
(2) Any formulas on the sheet? If so, changing Calculation to manual would definitely help!
(3) Roughly how many "Browser_type" entries do you have?
Thanks,
Brian.
ASKER
Brian - No worries - I figured out what was happening. Thank you for assisting on this one!
Thanks, Escanaba.
I figured out what was happening.
Are there any learnings for others who find this question? Edit: And me!
Thanks,
Brian.
I figured out what was happening.
Are there any learnings for others who find this question? Edit: And me!
Thanks,
Brian.
ASKER