Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff
 
Posts: n/a
Default VBA reseting variables

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA reseting variables bpeltzer Excel Discussion (Misc queries) 0 February 4th 06 04:52 PM
Passing Variables Jeff Excel Discussion (Misc queries) 1 November 4th 05 07:46 PM
Using Variables in Links Nate Excel Discussion (Misc queries) 0 October 11th 05 11:34 PM
augmenter le nombre de cellules variables du solveur excel Alfomeg Excel Discussion (Misc queries) 0 August 4th 05 10:40 AM
How do I use variables in Excel? XUT67 Excel Discussion (Misc queries) 4 July 22nd 05 10:04 PM


All times are GMT +1. The time now is 04:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"