Loop across Columns and down Rows

[flindy87]

Hi all,

I am trying to put together a macro that loops across cells along columns, once it gets to an empty/blank cell it loops down rows. If all the cells in that column and range of rows are empty/blank - the macro hides the column, then continues on until the range of columns has reached the end.

The range of columns will always be from 2 (B) to 23 (w)
The range of rows will always start from 11 and be a variable length (never more than 200).


So far i have the below code:

This code runs along columns fine and checks to see if the cell is blank on row 11. However i've not managed to code the second part of the loop where it then goes down that column to check if the subsequent cells in the rows beneath are blank.

The macro currently runs along the columns and then goes down to the next row (which i do not need).

Please Login or Register  to view this content.

I realise this may be rather confusing, however any help would be appreciated.

[stnkynts]

How about this:

Please Login or Register  to view this content.