close

Hi,

I have a Module with about 10 seperate macros? I mean these --gt; quot;Sub
Macros()quot;
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
quot;hold ontoquot; 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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()