Simple Code Needed

[nehpets12]

I have a macro that runs when the active cell = Enter this works fine unless the cell has a #N/A in it.

how do I stop the error "Run-time Error '13':


If ActiveCell = "Enter" Then Application.Run "'Lookup Pink Details.xls'!Del"

 

[stevebausch]

Two approaches:

First- refine your code, trap the errors .

Second - install an error handler, for errors you can't foresee.



I gave up on trying to locate a list of error constants; you could have gotten addtional help from me, IF YOU SUPPLIED DETAILs of what error 13 is.

Steve

 

[nehpets12]

Thanks Steve

Run-time error comes up as type mismatch

when the activecell is #N/A I want it to end the macro