Hi,
I need my macro to skip the next 3 lines of code in case of an error. Will i have to rewrite the entire code in my error handler or can i just write a simple line of code in my original macro?
Hi,
I need my macro to skip the next 3 lines of code in case of an error. Will i have to rewrite the entire code in my error handler or can i just write a simple line of code in my original macro?
Something like:
Please Login or Register to view this content.
You can use this line, but beware it masks the error, does not handle the error, it skips the error line.
Please Login or Register to view this content.
Can we see your code?
Also, what error are you trying to deal with?
If posting code please use code tags, see here.
The error is no value to filter as the first column filter removes all the options in certain cases. In that case i want my code to skip the copying part and move to the next section of the code which is some 3 lines after where the error occurs.
Sounds like an error you can deal with without using On Error.
Can you post the code, or is it secret?
check the count of visible cells in one column of the data-if it's greater than one, copy the data otherwise don't :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks