rosalie
11-13-2017, 09:24 AM
Hi everyone,
I am trying to hide a column using the below method:
Range("D:MY1").EntireColumn.Hidden = True
For which i receive the "Method Range of object global failed"
When I change to this: Sheets("TEST").Range("D:MY1").EntireColumn.Hidden = True
I get : Application defined or object defined error.
However in a separate procedure I have used:
Range("2:361").EntireRow.Hidden = True
Which has worked completely fine, hence why I'm, confused this method has not worked for columns.
I also much prefer referencing to columns in numbers, so if anyone could also let me know if that's possible here that would be great!
Thanks in advance!!!
I am trying to hide a column using the below method:
Range("D:MY1").EntireColumn.Hidden = True
For which i receive the "Method Range of object global failed"
When I change to this: Sheets("TEST").Range("D:MY1").EntireColumn.Hidden = True
I get : Application defined or object defined error.
However in a separate procedure I have used:
Range("2:361").EntireRow.Hidden = True
Which has worked completely fine, hence why I'm, confused this method has not worked for columns.
I also much prefer referencing to columns in numbers, so if anyone could also let me know if that's possible here that would be great!
Thanks in advance!!!