Posted to microsoft.public.excel.programming

PBcorn

external usenet poster

Posts: 79

function to re-calculate when cell format (colour) changes

I have a UDF which looks up all cells of a particualr colour in a range and
sums the cell values. However, the function does not re-calculate when the
colour of the cells in the range changes. How can I get this to work?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I Sum by Cell Colour or Format?	Ashley	Excel Discussion (Misc queries)	1	February 17th 10 07:05 PM
Format Cell Colour	scottymelloty	Excel Worksheet Functions	0	November 18th 04 04:13 PM
Format Cell Colour	scottymelloty	Excel Worksheet Functions	0	November 18th 04 04:08 PM
Format Cell Colour	scottymelloty	Excel Worksheet Functions	2	November 17th 04 08:19 PM
Conditional Format with VBA - Interior Colour of cell based on value from in-cell dropdown	Steve[_52_]	Excel Programming	5	June 15th 04 11:45 AM

All times are GMT +1. The time now is 08:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us