error handling in macros

[rbs123]

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?

[ragulduy]

Something like:

Please Login or Register  to view this content.

[AB33]

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.

[Norie]

Can we see your code?

Also, what error are you trying to deal with?

[JosephP]

Something like:

Please Login or Register  to view this content.

note that if you use this syntax any error that occurs after continue_here: will not be handled by your code

[rbs123]

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.

[Norie]

Sounds like an error you can deal with without using On Error.

Can you post the code, or is it secret?

[JosephP]

check the count of visible cells in one column of the data-if it's greater than one, copy the data otherwise don't :-)