Oh, something like this should do it:
code:
If LastRow <> 85 Then
PointlessVariable = MsgBox("Number of rows is not 85.", vbOKOnly, "YOU FAIL!")
End If
You could make it a bit more helpful by showing a different message depending on whether the number of rows is less than 85, or more.
edit:
Just in case you didn't know, '<>' means 'not equal to'. Sensible languages use '!=' or '!=='.
EDITED: 1 Dec 2010 15:13 by CAER