Delete Data Based On Cell Value

[terratushi]

Hi,

I have some code which checks a cell value and deletes the entire row

Please Login or Register  to view this content.

Is it possible to amend the code so instead of deleting the entire row it only deleted columns A:K, I would also need the delete to "shift cells upwards"

Any help would be great,

Thanks

[TMS]

Maybe change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.