| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting excel to recalculate on format
Hi Dale
You're out of luck, formatting doesn't trig any events or recalculations. This event is hign up on my wishlist too. -- HTH. Best wishes Harald Excel MVP Followup to newsgroup only please. "Dale Wright" skrev i melding ... Hi, I was wondering if anyone could shed some light on this for me. I have a spreadsheet that needs to count the number of cells in a range that are in italics. to do this i have written a UDF called sumItalic which takes a range as a variable and calculates it correctly. However it only updates when a cell is modified, not when the data in question is turned to italics. I have tried Application.Volitile in the function but i don't know hat else to try. Running Excel '97 SR 2 Cheers, Dale |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 set a row or column to not recalculate | Excel Worksheet Functions | |||
| Is there a way to recalculate trend lines in Excel charts? | Excel Discussion (Misc queries) | |||
| Why does Excel recalculate when I make a different filter selectio | Excel Discussion (Misc queries) | |||
| How do I set Excel to recalculate a sheet on a frequency (5 sec)? | Excel Discussion (Misc queries) | |||
| Excel worksheets will not recalculate a | Excel Discussion (Misc queries) | |||
![Harald Staff[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
