VBA to Extract Data using advanced Filter

I have a macro to extract data from sheet "current Data" to sheet "New Account numbers Added"

Please Login or Register  to view this content.

the above code runs perfectly and extract the data


However, If the range F2 to the last row in Col F is blank, then I would like the Macro to exit


I have tried to write code to get this to work, but get a compile error: "Else without if

See additional code below to exit sub if F2 to last row in col f is blank

Please Login or Register  to view this content.

your assistance in resolving this is most appreciated

Try replacing these 3 lines:

Please Login or Register  to view this content.

with this 1 line:

Please Login or Register  to view this content.

Thanks for the help Sintek. Code works perfectly