Autofilter column B for blanks, then delete all visible rows.

HTH

Bob

"JohnUK" wrote in message
...
Hi, I am after a piece of code that will delete all empty rows downwards
from
1st row until it hits data in column B. I can see plenty of threads
explaining how to delete upwards until it hits data, but not downwards.
Help greatly appreciated