Hidden = True
Case "AC42U"
Columns("E:J").EntireColumn.Hidden = True
Range("C5") = "AC"
End Select
Application.ScreenUpdating = True
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Anil Pandit
: Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------------------------------------------
>> To post to this group, se
Range("E1:G1,J1:l1").EntireColumn.Hidden = True
>Case "AC42U"
> Columns("E:J").EntireColumn.Hidden = True
> Range("C5") = "AC"
> End Select
> Application.ScreenUpdating = True
> End Sub
>
> Don Guillett
> Mic
ct
Application.ScreenUpdating = True
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Anil Pandit
Sent: Wednesday, March 28, 2012 11:04 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Run-time error message: Method 'Hidden' of object
Hi,
I'm new to VBA and I'm posting this because I've been tearing my hair out
over this all day, so I hope someone has seen this before and can point me
in the right direction.
I have created a worksheet change event which hides some columns according
to a string that is chosen from a list in
