Loop Across Columns...If Blank Cell, Loop Down Rows

Trying to code in a loop...

It needs to loop across columns on row 11, when it hits a blank/empty cell, it loops down that column....eg Hits a blank cell, goes down and hits another blank cell, goes down again etc until it gets to a pre-defined range of rows (Lets just make it easy and say 100 rows).

If every cell within that column is blank, the macro hides that column.

I then need the macro to carry on until it hits the end column.

Columns start from 2 (B) and go across to 22 (W).


I currently have the below...which does not work and i'm not sure why.

Any help would be greatly appreciated.

Please Login or Register  to view this content.

HI flindy87,
Try this, I think it might be what you need.

Please Login or Register  to view this content.