Halt a macro if input file exceeds a set number of lines

[macrokam]

I have a macro that opens a file and reformats it along with pulling in other information. I want the macro to stop and give the user an error message if the input file exceeds 50,000 rows. Is there a way to code this?

Thank you.

 

[Joe4]

Welcome to the Board!

If you place this bit of code at the beginning of your macro, it should do that:

    If ActiveCell.SpecialCells(xlLastCell).Row > 50000 Then
        MsgBox "File exceeds 50,000 rows", vbOKOnly, "ERROR!"
        Exit Sub
    End If

 

[macrokam]

Awesome! Thank you very much.