Hi All,
I am encountering error 1004- Unable to set the Hidden property of the Range class. I can’t understand why it’s happening.
What I am trying to do:
ComboBox1 will hide and unhide rows from 6 to 24 depending on the selection
Select 1: row 6 shows, rows 7-24 hide
Select 2: rows 6-7 show, rows 8-24 hide
Select 3: rows 6-8 show, rows 9.24 hide
‘etc
ComboBox2 will hide and unhide rows from 33 to 37
ComboBox3 will hide and unhide rows from 42 to 48
ComboBox4 will hide and unhide rows from 52 to 62
I have attached the file. Please help!
Thank you in advance
Bookmarks