Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Iteration
On my spreadsheet i have a circular reference, i need this circular formula however the message telling me i have one is confusing my users when they open the spreadsheet. I have figured out that turning on iteration fixes the error message, so i wish to use VBA to turn on iteration when opening the workbook. Logically this should work shouldn't it? Private Sub Workbook_Open() Application.Iteration = True End Sub but the error message still comes up and then it turns the iteration on. So i thought maybe if i turned off auto calculation and then back on after i.e. Private Sub Workbook_Open() Application.Calculation = xlManual Application.Iteration = True Application.Calculation = xlAutomatic End Sub And again, the error message comes up and then it turns off the calc, turns on the iteration and so on..... I have tried this sub on each worksheet and in a module, it doesn't work. Please can someone tell me how to make this work. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use Excel Solver (for an Iteration in a row) for several no.of times? | Excel Discussion (Misc queries) | |||
Excel Iteration Program | Excel Discussion (Misc queries) | |||
Iteration problem (Excel 2002) | Excel Worksheet Functions | |||
Help requested for Excel Iteration problem | Excel Discussion (Misc queries) | |||
Excel 97 - Application.Iteration is always FALSE? | Excel Programming |