Hi All,
Having issues with a macro im trying to get working for a button. All it is: selecting multiple columns and hiding them. This is it (below) and VB is rejecting the range,... or any range for that matter.
Anyone got ideas of why its not working on the button?
Thankyou very very much!
Having issues with a macro im trying to get working for a button. All it is: selecting multiple columns and hiding them. This is it (below) and VB is rejecting the range,... or any range for that matter.
Code:
Private Sub CommandButton1_Click()
Sheets("Holland").Select
Range("D:D,H:H,L:L,P:P,T:T,X:X,AB:AB,AF:AF,AJ:AJ,AN:AN,AR:AR,AV:AV").Select
Range("AV1").Activate
Selection.EntireColumn.Hidden = True
Sheets("CONTROL").Select
Range("D1").Select
End Sub
Anyone got ideas of why its not working on the button?
Thankyou very very much!