Delete certain cells if cell is blank

i have the following code (that works!) to delete rows if the cell in column B in that row is blank. I need this changed to only delete cells in column A, B and C but not the entire row.

so if the cell is blank in column B i only want it to delete and shift up the first three columns of that row instead of the whole row.

heres the code

Please Login or Register  to view this content.

thanks for any help
JD

Correction
I guess i didn't really explain it right in the first post

i want the code to only delete and shift up rows in column A, B, and C only if for that row column A, B, and C are all blank

I have data outside columns A, B, and C so this is why i can not simply delete the whole row.

any help

Hi JD,
try it

Please Login or Register  to view this content.

Figured it out

Please Login or Register  to view this content.