Link to home
Create AccountLog in
Avatar of xllvr
xllvrFlag for United States of America

asked on

Excel vba - If cells in multiple columns are empty, delete row

Hello Experts!

Attached is a sample of the data I'm cleaning up.  I'll need to delete rows whenever the corresponding cells in Columns B:E are empty.  I have highlighted in yellow what satisfies that condition.  

I would very much appreciate your help with code to delete rows where the cells in B:E are empty.

Thank you!
Avatar of Haris Dulic
Haris Dulic
Flag of Austria image

No attachment
Avatar of xllvr

ASKER

Hi Haris,

I don't see a post or an attachment here.  Were you intending to comment?
In your question you are saying " Attached is a sample of the data I'm cleaning up. " but no attachment is there...
Avatar of xllvr

ASKER

Oh no!  So strange...I attached it but failed to hit upload earlier.  Apologies!

Here you go.
EE-Delete-Row-Test.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Haris Dulic
Haris Dulic
Flag of Austria image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of xllvr

ASKER

That worked beautifully!  Thanks so much for a great solution, Haris.  I'm so appreciative.