Halt Operation Macro

[bschulze]

I am creating a macro to open a file (Worksheet A) in a particular folder and then from there I am copying the worksheet A into the worksheet with the macro. There will be times were this file WILL NOT be present in that folder. When this is the case I want the macro to END SUB and not ERROR. I am not sure how to write this. I am pretty sure it is very basic however I am just getting back into Macros. A little help would be greatly appreciated.

Thanks

 

[Oorang]

On Error Resume Next
'Your code that accesses the file goes here
If Err.Number <> 0 then End
On Error Goto 0