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
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