Macro for iteration

How long is a piece of string?

A little more information might be helpful.

set the iteration to "Allow iteration"
in a1 add value 1
in b1 formula = a1+b1 which is circular reference
press "F9" each time you press F9 the circular formula iterates 100 times