I am trying to write a VBA (I am a beginner so it's very difficult....)

I have an array of names in rTable A4 To B53 As Range. If a name changes to "VACANT" or "0" I want a subroutine to automatically delete the information from the corresponding row where the name once was.

The information to be deleted is only contained within certain columns and cells (C4:C53, G4:G53, K4:R53).

Any help is much appreciated!