Jagwarman
asked on
find a word [include wild card] and delete Row
Please help. I just want to find "Manually Constructed" but best to look for Manually* [* being the wild card* and then delete the row using VBA
appreciate your help
appreciate your help
ASKER
Column A need VBA
Do it manually and record the steps with the VBA Recorder. That will give you the steps required.
Thanks
Rob H
Thanks
Rob H
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
BTW, when data is filtered, selecting the visible rows as a block and deleting will only delete the visible rows. When the filter is then removed the rows which were hidden will re-appear and will not be affected by the delete.
Just saying because for a simple filter such as this I see it as a bit overkill to put in VBA.
Thanks
Rob H
Just saying because for a simple filter such as this I see it as a bit overkill to put in VBA.
Thanks
Rob H
ASKER
Exactly what I needed thanks
Use Auto Filter and set Filter to 'Contains' ~ Manually
Thanks
Rob H