keeping variables in scope

[LLoyd]

I need to run a macro, allow the user to do some stuff in Excel, and then run another macro. The thing is, the second macro needs to use variables produced by the first macro and when the first macro ends the variables go out of scope and become empty. The variables are in a standard module.

Is there a way to keep VB variables in scope and allow the user to use VB, or do I have to come up with a way of using the sheets to store variables (which will make my second macro slower)?

Cheers,
LLoyd

 

[Dave Hawley]

I must say also that I never have any probs with Public Variable loosing there value unless the Workbook is close.


LLoyd, if you do not have any "End" Statements and you are using the Public Statement, the only other thing I can think of is you may not be doing this in a Standard Module! Perhaps you are doing so in a Private Module (UserFor, Workbook, Worksheet)?