the error is that there's a combobox in the way & it won't let you
programatically hide the row. there's nothing wrong with the sub
(that i can see).
you'll have to skip the row if it contains a combobox.
hth
susan


On May 14, 9:51*am, New2Macros
wrote:
I'm using the following macro to hide/show rows, but I get a "run-time error
'1004' Unable to set the Hidden property of the Range Class" if the row
contains a combo box. *The combo boxes are inserting information into
adjoining cells on the same row. *What could be causing the error?

Private Sub Worksheet_Change(ByVal Target As Range)
* *If Target.Address = "$A$2" Then
* * *Range("2:" & Rows.Count).EntireRow.Hidden = False
* * *Range(CStr(3 + 2 * Range("A2").Value) & ":" & _
* * * * * * *Rows.Count).EntireRow.Hidden = True
* *End If
*End Sub