Hankins
04-27-2007, 07:40 AM
I have the following macro that I've composed in Excel 2000. When I transfer it to Excel 97 I get the error message below.
Macro:
Sub Pipe_Order()
'HIDE ROWS THAT ARE BLANK
BeginRow = 11
EndRow = 300
CHKCOL = 4
For ROWCNT = BeginRow To EndRow
If Cells(ROWCNT, CHKCOL).Value = "" Then
Cells(ROWCNT, CHKCOL).EntireRow.Hidden = True
End If
Next ROWCNT
End Sub
Error Message: Runtime Error 1004, Unable to set the Hidden property of the range class.
Any ideas?
Macro:
Sub Pipe_Order()
'HIDE ROWS THAT ARE BLANK
BeginRow = 11
EndRow = 300
CHKCOL = 4
For ROWCNT = BeginRow To EndRow
If Cells(ROWCNT, CHKCOL).Value = "" Then
Cells(ROWCNT, CHKCOL).EntireRow.Hidden = True
End If
Next ROWCNT
End Sub
Error Message: Runtime Error 1004, Unable to set the Hidden property of the range class.
Any ideas?