M
mirbab
I have a Excel97 workbook where results are calculated in one row o
sheet DVypocetZivin. I am tracking user on different sheet wit
Worksheet_SelectionChange to show results for the proper row. I a
collecting the results in different sheet which is using furmula
like:
e.g. C7 contain: = IIF(riad=$A7;DVypocetZivin!E$45;C7)
with intentional cycling, where riad and $A7 are holding row numbers.
Everything is working OK with small problem: after opening the book
am getting cycling warning. I know that I can write macro to cop
results and other option is to calculate manually.
My questions are:
1. Is it possible to ban cycling warning in Ex97? (how)?
2. Is there function I can include in IIF which will do nothing (an
will not change the value)
3. Do you have other sugestions?
Thanks
Miro
sheet DVypocetZivin. I am tracking user on different sheet wit
Worksheet_SelectionChange to show results for the proper row. I a
collecting the results in different sheet which is using furmula
like:
e.g. C7 contain: = IIF(riad=$A7;DVypocetZivin!E$45;C7)
with intentional cycling, where riad and $A7 are holding row numbers.
Everything is working OK with small problem: after opening the book
am getting cycling warning. I know that I can write macro to cop
results and other option is to calculate manually.
My questions are:
1. Is it possible to ban cycling warning in Ex97? (how)?
2. Is there function I can include in IIF which will do nothing (an
will not change the value)
3. Do you have other sugestions?
Thanks
Miro