I have had this happen also. Make sure you use the Reset button under the Run
menu item before you run the macro again. and don't forget to initialize all
variables you use to zero, especially the loop variables. Can't remember exactly
which was the one that really did the trick, probably reset.
Atilla Korkmazoglu wrote:
> I have for different big tables on different wokbooks, I have consolidated
> the data by using several vicious circles ( For.. Next etc) one within
> another. Each time I start the macro (It takes around ten minutes to finish)
> I am getting different totals even if I dont make changes on the tables. It
> is really weird, can it be because of too big tables or too many variables.
> Thanks for your help!!!