Unable to set the hidden property of the range class

Hi guys,

This one is frustrating me no end!

I have a very simple macro. I've been using this macro for ages with no problems but now all of a sudden it doesn't work. I get the runtime error 1004 - "Unable to set the hidden property of the range class". All I've done is add a few extra columns in and as a result I've had to change the range references in the macro, but I don't see why this should stop the macro from working. The code is:

Please Login or Register  to view this content.

Does anyone know any reasons for why this would happen? Like I say, the only thing that has happened is I've added a few extra columns in the sheet. The code is exactly the same except for a change in the range references.

Thanks,

Chris

.....Just to add something to my previous post....

I've just been experimenting with this macro. I've now tried the following:

Please Login or Register  to view this content.

This allows me to unhide all columns in the range A to EZ. Then I tried:

Please Login or Register  to view this content.

Which is really just unhiding the columns and then hiding the same ones again. But it won't let me hide them - I get the error message on that particular line!

Again, can anyone offer any tips....seems like it should be simple but is just wierd!

Thanks,

Chris