Only specific columns are hidden based on range

Hi biznez

Wanna give this a try

Please Login or Register  to view this content.

Did you adapt the code to suite your requirements.i.e. Change

Please Login or Register  to view this content.

to your sheetname.
Upload your file so that we can take a look.

Herewith sample file that tests fine

Since the code looks for the last column in row 1, I'm guessing @biznez's worksheet only has the first column in row 1 filled. thus the code's ability to hide the first column, but then in the next iteration would error at Columns(0). Change Cells(1,) to whatever row better represents the last column of your data.

But of course this is just a guess w/o seeing the data.

@ walruseggman

That is very possible....Thanks. Did not think of that. It then would defeat the object of he's request....

Im trying to select the last used column to 12 columns before

Glad it helped. thanks for rep points.