GoTo compile error: "Expected: line number or label"

Hello

The red GoTo pair below are returning the compile error "Expected: line number or label". The only difference I can see between this GoTo and the others I've used is that this GoTo is not nested within an IF statement. I've been searching for information on whether the GoTo command must be nested within some other statement in order to function (when it's not the "On Error GoTo" command), but I haven't been able to turn up any solid information on this.

Does GoTo have to be nested, or is there something else wrong here? I don't define "Shared" as an argument, function, sub, etc., anywhere else.

Please Login or Register  to view this content.

"Shared" is apparently a reserved word to VBA; use a different label.

I think shared is a reserved word & cannot be used like thgis. Change it to MyShared

I'm sure that your cod could be greatly streamlined but without full sight of the code it's hard to advise

e.g.

Please Login or Register  to view this content.

could be

Please Login or Register  to view this content.

Edit: had trouble posting this & didn't see shg's reply. Forum doesn't seem to getting any better

Roy, is it ever going to get better? Have you tried Find all posts by ...

I know someone who should never be allowed access to a keyboard again.

You can of course post your code & ask for suggestions to improve it