J
J S
I've written a function that calculates the sum of all the cells in a
worksheet that have red colored text.
When I use this formula in a cell it does not automatically recalulate it
self when ever the user changes the TEXTCOLOR of a cell to be the color red.
I already added the application.volatile statement but appartently the
function will still only recalulate when a value is changed and not when a
color/format is changed!
Is there anyway to get a function to automatically recalculate when a color
on the sheet is changed? Is there any onFormat Change events?
-J
worksheet that have red colored text.
When I use this formula in a cell it does not automatically recalulate it
self when ever the user changes the TEXTCOLOR of a cell to be the color red.
I already added the application.volatile statement but appartently the
function will still only recalulate when a value is changed and not when a
color/format is changed!
Is there anyway to get a function to automatically recalculate when a color
on the sheet is changed? Is there any onFormat Change events?
-J