Hide Columns Loop Fails Over Multiple Sheets

Hi all,

I hope I get this right as it's my first post. I am trying to loop through a list of sheets. In each sheet I want a range of cells to be assesed and then the columns hidden based on the cell value. I can get this macro to work as long it is for one sheet. As soon as I extend the loop to look at more than one sheet, I get an error message. It's the first time I have used the Union function, something I am not used to. Any help would be most welcome, I've been looking at this for ages!

Please Login or Register  to view this content.