Forum Discussion
Solved
VBA Run-time error '1004' when Hide/Show Rows
Hello All, I am confronted with an error message - "Run-time error '1004': Unable to set the Hidden property of the Range class" when hiding/showing entire rows. Cells A1:A10 are given values...
This is because the ListFillRange is set to A1:A10 and you are trying to hide those rows. An easy fix is to use On Error Resumen Next like below...
On Error Resume Next Rows(ShowRows).Hidden = False Rows(HideRows).Hidden = True On Error GoTo 0
This is because the ListFillRange is set to A1:A10 and you are trying to hide those rows. An easy fix is to use On Error Resumen Next like below...
On Error Resume Next
Rows(ShowRows).Hidden = False
Rows(HideRows).Hidden = True
On Error GoTo 0
Subodh_Tiwari_sktneer Thanks for explaining this. And your suggested solution worked well!
You're welcome jmpjmp!
