rhombus4
Well-known Member
- Joined
- May 26, 2010
- Messages
- 586
- Office Version
- 365
- 2016
- Platform
- Windows
Hi
I can hide the rows I want by using
However I have a worksheet selection change which does some stuff when selecting rows 10 to 100 and I get an error
run time error 1004 - Unable to set the Hidden property of the Range class
I tried turning off application.enableevents but still same error
I can hide the rows I want by using
VBA Code:
Rows("23:35").EntireRow.Hidden = True or Rows("23:35").Hidden = True
However I have a worksheet selection change which does some stuff when selecting rows 10 to 100 and I get an error
run time error 1004 - Unable to set the Hidden property of the Range class
I tried turning off application.enableevents but still same error
VBA Code:
Application.EnableEvents = False
Rows("23:35").EntireRow.Hidden = True
Application.EnableEvents = True