Code executes 8 times without loop statements. Why?

Hi all

I was playing aroung some VBA code, but the code executes 98 times and I don't know why.

For example, range A1 contains 5. When I type, say 3, in A1, I want A1 to show me 8 (5+3). Then I may type 10, in this case A1 must show 18 (8+10). And so on.

I decided to place entered values in different column, then sum them in A1 with below stated code

Please Login or Register  to view this content.

But this code executes 97 times, and I can't figure out why?! I just want to know the reason of this behaviour...

just bumping that

With worksheet_change macros, if you write to the worksheet you REtrigger the event code. Not all ws-Change macros make changes to the actual sheet, but if you do, you need to disable events so that no other macros trigger until the routine completes.

Please Login or Register  to view this content.

PERFECT!!!!!!!!!!!!!!
Tanks for explanation....