GURPS Spaceships Design Spreadsheet

Mgellis · 08-02-2010, 06:24 PM

I keep getting an error message when I use the first system of the central hull on the new spreadsheet. It happens for some systems (armor, etc.) but not all. The debugger points to this code...

'HideRows

For HiddenRow = 1 To 206

If ActiveSheet.Cells(HiddenRow, 1) = 0 Then
Rows(HiddenRow).EntireRow.Hidden = True
Else
Rows(HiddenRow).EntireRow.Hidden = False
End If

Next HiddenRow

Range("B5").Select

ActiveSheet.Unprotect
End If

I have no idea what any of this means, but the line that keeps getting highlighted as a troublemaker is...

If ActiveSheet.Cells(HiddenRow, 1) = 0 Then

Anyway, I hope this helps.

Mark

08-02-2010, 06:24 PM	#11
Mgellis Join Date: Nov 2004 Location: Flushing, Michigan	Re: GURPS Spaceships Design Spreadsheet I keep getting an error message when I use the first system of the central hull on the new spreadsheet. It happens for some systems (armor, etc.) but not all. The debugger points to this code... 'HideRows For HiddenRow = 1 To 206 If ActiveSheet.Cells(HiddenRow, 1) = 0 Then Rows(HiddenRow).EntireRow.Hidden = True Else Rows(HiddenRow).EntireRow.Hidden = False End If Next HiddenRow Range("B5").Select ActiveSheet.Unprotect End If I have no idea what any of this means, but the line that keeps getting highlighted as a troublemaker is... If ActiveSheet.Cells(HiddenRow, 1) = 0 Then Anyway, I hope this helps. Mark