G
Guest
Hi everyone!
I have been looking for a way to force, coerce, beg a worksheet to update,
or maybe the better word is recalculate its cells either by a specific
keystroke, or better yet, when the cell output is changed.
I have been working with bypassing the conditional format limitation, and
have that taken care of. Unfortunately, the cells that have the conditional
format applied reference the calculated values in other cells. I can change
the values in the "other" cells without a problem, but the cells that I need
to change do not update the formatting.
I can select each cell individually, and hit the Enter key, and VIOLA! the
cell format changes, but it will not do it automatically.
I have looked at application.volitile, application.refreshall, but have come
up empty.
Does anyone have any suggestions?
Thanks a bunch!
I have been looking for a way to force, coerce, beg a worksheet to update,
or maybe the better word is recalculate its cells either by a specific
keystroke, or better yet, when the cell output is changed.
I have been working with bypassing the conditional format limitation, and
have that taken care of. Unfortunately, the cells that have the conditional
format applied reference the calculated values in other cells. I can change
the values in the "other" cells without a problem, but the cells that I need
to change do not update the formatting.
I can select each cell individually, and hit the Enter key, and VIOLA! the
cell format changes, but it will not do it automatically.
I have looked at application.volitile, application.refreshall, but have come
up empty.
Does anyone have any suggestions?
Thanks a bunch!