use a macro on a closed workbook

[tla280]

Hey all,

I've written a macro that works fine if I call it from the active sheet (that's how I wrote it). But I now need to use the same macro across multiple sheets in multiple work books. Or I guess I could copy all the ranges my macro needs from the various workbooks to this new one. Then run my macro. Either way I need some help.

My macro in a nutshell, takes a range and sorts it, then after culling out specific rows passes them to a function to summarize them. That gets passed back as an array then output to a range. There are two lines where I explicitly use sheet references. When I sort and when I output. Both use the active sheet property. Im actually on lunch and posting on my phone. If you need to see my code I can supply it shortly.

Any advice appreciated.

 

[tla280]

Bump. Anybody?

 

[pboltonchina]

Post your code

 

[tla280]

I'm afraid I've run into a problem there. I can't. Login to forums it seems on work computers and can't copy all the code on my phone via email so I'm stuck until I get home in about 2 hours.

But so far I can call the function from another workbook. And get it to do everything correctly. Just trying to get it to return something. Because that sub was not written to return a value or variable