Need Help Linking Two Modules...

[Lidsavr]

I am writing a large VBA program will create over 100 pivot tables and 150 charts when I am through. The code in the first module is nearing its limit and I will need to start coding in a second module soon.

I know there is a way to link to modules together, so when you execute the code it runs straight through because I used the code three years ago at another company that I am not longer with, so I don't have access to the file to peek at it.

Can someone help me out with the code?

Thanks,

Lidsavr

 

[AlphaFrog]

Not to sound pretentious, but I have to ask if you are replicating 150 times the code that makes each pivot table and chart ? Is that why your code is so long?

 

[Lidsavr]

AlphaFrog,
You not being pretentous from my viewpoint.

Yes, each chart has it's own set of code, although each refers back to the first table to save memory. (Same pivotcache)

How do I use less code to do this? (As soon as I am finished with my weekly reports that I am doing manually, I will post a portion of the code and you can see what I am doing.)

Thanks,

Lidsavr