This section of code is causing an error:

    On Error GoTo EndMacro
    Range("A2:I" & Lastrow).SpecialCells(xlCellTypeVisible).Copy
the error is: "No Cells Were Found"

and that is ok, its what I expect to happen. So If this error happens, I want to redirect the code to the end of the macro but "GoTo EndMacro" isnt doing that for some reason. I have that Label in my script but the code just doesnt want to be redirected to it.

any1 know why? is there a simple solution?