Circular References - can they be a good thing?

patrickmuldoon99

Active Member
Joined
Jun 27, 2006
Messages
345
Hey all

I was wondering if anyone had any examples of useful application of circular references? I have had a look on the 'net and found that it can be used to iterate without a macro (i.e. by turning calculation off and hitting F9 constantly, you can make a cell iterate by a given amount each time)

Interesting, but I can't see a huge use for it!

Cheers all,

Patrick
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,113,862
Messages
5,544,726
Members
410,630
Latest member
JFORTH97
Top