Call sub for another sheet

**Marianus** · 06-27-2013, 03:16 PM

Hi

I have problem a I want call sub() for other sheet when is activ , how

Thnaks

**Spritz** · 06-27-2013, 03:59 PM

type this code wherever you want to call your sub (Assuming it is called sub)

Please Login or Register  to view this content.

**Marianus** · 06-27-2013, 04:21 PM

call its error

I want from sheet1 call sub from sheet2

or

I want call sub from any sheet

how I want call sub from others sheet

**Spritz** · 06-27-2013, 04:22 PM

Originally Posted by Marianus

call its error

I want from sheet1 call sub from sheet2

or

I want call sub from any sheet

how I want call sub from others sheet

Can you post an example of your code so i can see what you are asking for?

**Marianus** · 06-30-2013, 04:43 AM

this is excel

I want use button "Copy - call sub sorting" in sheets report , I want call another sub before I start copy

PS: how to load excel when i sse excel icons in forum , I copy as LAMA (noobs)

**jindon** · 06-30-2013, 04:55 AM

Change the line to

Please Login or Register  to view this content.

**Marianus** · 06-30-2013, 05:10 AM

working great , Thank you

this is working excel :

- callSub.vA002.xlsm

PS: how to load excel when i sse excel icons in forum , I copy as LAMA (noobs)