Make variable Goto command

[rpinxt]

I have this sub :

Please Login or Register  to view this content.

So variable a is coming from another sub and works (checked with msgbox).

a is equal to carrier1, carrier2 or carrier3.

Now I wanted to, based on what vairable a is, directly go to the correct VBA part.
But it is not working like this.
Giving me label not defined.

Is there a way around outside working with IF's?

[rorya]

There are exceptions, but a very good rule of thumb is: don't use Goto. It is certainly not necessary here when you could use any number of options from If..Else to Application.Run. If you need to run different code based on an argument, you should almost certainly be calling different routines, not having all the code in one.

[rpinxt]

Hmm ok rorya.
I understand what you say about using separate routines.

However in this case they (i my opinion) do belong to eachother.

Bit more background.
The code will copy data from a worksheet (in the same worbook) to another worksheet (in the same workbook).
Now there a 3 scenario's how to filter the source data and copy the data.

I want to keep these 3 parts together so its more clear to understand what the macro does (in the 3 cases).

[rorya]

That still doesn't sound like a scenario for Goto. It sounds like one filter routine that takes different filtering parameters, and if you only have three options, a simple If...Then or Select Case would suffice.

[rorya]

Purely for academic value, you could do this:

Please Login or Register  to view this content.

in much the same way that you can use On Error Goto -1, but you really shouldn't.

[rpinxt]

Thanks rorya