CodingExcel VBA Macro
If LastRow <> 85 Then PointlessVariable = MsgBox("Number of rows is not 85.", vbOKOnly, "YOU FAIL!") End If
Thanks Caer
Once i knew how it was supposed to be and a little tweak here and there it works a treat.
If i add a line it fails and if i take one away it fails. Brilliant thanks a lot