| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Calculate() , How to find affected cells?
Hi,
Worksheet_Calculate(), I want to make cells change color when its value change after recalculate. Worksheet_Change() can use "Target.address" to locate the changed cells How to find affected cells for Worksheet_Calculate()? Worksheet_Calculate() have no "Target.address" Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locate changed cells with Worksheet_Calculate() | Excel Worksheet Functions | |||
| Formulas Affected by Insert Row | Excel Worksheet Functions | |||
| Formulas Affected by Insert Row | Excel Discussion (Misc queries) | |||
| inserting row...but the formula is not affected | Excel Programming | |||
| "over-lay" one range onto another range so that only blank cells are affected | Excel Programming | |||
Threaded Mode
