Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have a Module with about 10 seperate macros? I mean these -- "Sub Macros()" I have declared variables at the top of the module so that each macro can use the variable that is reset periodically in other macros. Then I have this combobox that calls a Main macro that calls the macros and basically calculates a fund. The problem is that when I run the macro, (and the values of the fund are print out on a sheet in the workbook), and then run it again, the values change. So I am assuming that some of the variables are not being reset or "hold onto" their previous value. The fund should not change because I am running the same values. Does anyone have any advice if the variables are not being reset, or if there is a way to automatically reset the variables? i would appreciate any help on this thanke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA reseting variables | Excel Discussion (Misc queries) | |||
Passing Variables | Excel Discussion (Misc queries) | |||
Using Variables in Links | Excel Discussion (Misc queries) | |||
augmenter le nombre de cellules variables du solveur excel | Excel Discussion (Misc queries) | |||
How do I use variables in Excel? | Excel Discussion (Misc queries) |