Dim LastRow As Integer Set Lastow = Main.Range("A65536").End(xlUp).Row
Thanks Caer
The problem is I dont know what to do with it once ive got it!
Any ideas would be really appreciated
If LastRow <> 85 Then PointlessVariable = MsgBox("Number of rows is not 85.", vbOKOnly, "YOU FAIL!") End If