Hi

We have a fixed import file we run through excel for invoicing. It always has exactly 85 rows.

Is there a check in someway I can write to the begining of the macro if it has more or less than 85 rows it stops by displaying an error message?

The sheet concerned is called Main

Thanks in advance

Dim LastRow As Integer
Set Lastow = Main.Range("A65536").End(xlUp).Row

FORJ Forum

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

FORJ Forum

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