Hi all,
I have the following code that only hides columns C:GM instead of C:GW
Has anyone any idea why this would be? Maybe a conflict?
I have the following code that only hides columns C:GM instead of C:GW
Has anyone any idea why this would be? Maybe a conflict?
Code:
Sub View_Work()
Sheets("Estimate").Unprotect Password:="1234"
Columns("C:IN").Select
Selection.EntireColumn.Hidden = False
Columns("C:GW").Select
Selection.EntireColumn.Hidden = True
Columns("IA:IN").Select
Selection.EntireColumn.Hidden = True
Columns("GX:HZ").Select
Selection.EntireColumn.Hidden = False
Range("A1").Select
Sheets("Estimate").Protect Password:="1234"
End Sub
[code/]
Many thanks for any help
Last edited: