This section of code is causing an error:
the error is: "No Cells Were Found"
Please Login or Register to view this content.
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?
Please Login or Register to view this content.
Two possibilities spring to mind:
1. You have already used on On Error Goto statement somewhere without then using a Resume statement.
2. You have your VBE set to break on all errors.
Remember what the dormouse said
Feed your head
@romperstomper yes I have used an "On Error GoTo" statement somewhere without using "Resume"
I basically have this sort of set up:
where would I put the resume? before the "Part2" section?Please Login or Register to view this content.
What you should do is rewrite and restructure your code! Impossible to be specific with no actual code to go on, but as a general guideline you should have one error handler per routine (if any).
The fact that you have all those different Goto statements suggests that you should probably be using multiple routines, or at the very least restructuring the code you have now so that it doesn't leap around so much.
For your specific visiblecells issue here, I would actually use something like:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks