find text, offset to the left 2 places resize and delete.

Hi folks,

I have the following code that loops through a worksheet looking for cells that contain "ab" it then deletes the cell containing "ab" and also the cell immediately to the left, the rows below then move up 1 place.

Please Login or Register  to view this content.

What I am trying to achieve is when cells containing "ab" are found the cell containing "ab" and also 2 cells immediately to the left are deleted, the rows below then move up 1 place.

Also instead of searching worksheet Bob I would like it to search the open sheet.

Thanks for any help

Hi Quekbc,

Works like a charm, just what I was trying to do.

Many thanks for your help and time