Hiding columns
This is driving me mad. Can anyone suggest what the problem may be.
I have a simple line of code If bMy = False Then Worksheets("Cim").Range("A1:EY1").EntireColumn.Hid den = True Which keeps falling over in the second part with the "Unable to set the Hidden property of the Range Class" message. Using the Immediate window I can succesfully hide A1:ET with:- Range("a1:et1").EntireColumn.Hidden=true but as soon as I change this to Range("a1:eu1").EntireColumn.Hidden=true I get the error message. It suggests that there's some characteristic of column EU that it doesn't like, but I'm at a loss to understand what it may be. Any ideas?? Usual TIA |
Hiding columns
Is that worksheet protected in any way?
-- HTH RP (remove nothere from the email address if mailing direct) "Richard" wrote in message ups.com... This is driving me mad. Can anyone suggest what the problem may be. I have a simple line of code If bMy = False Then Worksheets("Cim").Range("A1:EY1").EntireColumn.Hid den = True Which keeps falling over in the second part with the "Unable to set the Hidden property of the Range Class" message. Using the Immediate window I can succesfully hide A1:ET with:- Range("a1:et1").EntireColumn.Hidden=true but as soon as I change this to Range("a1:eu1").EntireColumn.Hidden=true I get the error message. It suggests that there's some characteristic of column EU that it doesn't like, but I'm at a loss to understand what it may be. Any ideas?? Usual TIA |
All times are GMT +1. The time now is 01:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com