Macro to delete entire column if no entries are made

[MiGGsHz]

Hello friends,

Can you help me with the following?
I am trying to create a macro that will delete an entire column if no entries are made from cell B6 and down. B1:B4 is a header.
If there is at least one entry, then the macro should not delete the column.
If there is an entry, then the entire B column should be deleted, including B1:B4.

So far this is what I've got:

Please Login or Register  to view this content.

This doesn't work for me because it's focusing on the entire column and not a range, like B6 and down.

I've tried incorporating this but it's not working either :S

Please Login or Register  to view this content.

Can someone please help me? If you need more info, please let me know. I can't seem to get this to work!

[sktneer]

You may try something like this....

Please Login or Register  to view this content.

[MiGGsHz]

That worked incredibly well!

Thank you sktneer!

[sktneer]

You're welcome. Glad I could help.
And thanks for the feedback.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.