Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell value change event
hello I have alteast 1000 rows and 1 column in excel sheet and each
cell in the excel sheet has a formula. I need to track the change in each cell. If i were using excel_change event it would have been easy for me to track the address of the changing cell. Since i am using formulas in all cell i can trap the change event only by sheet_calculate event ,but the drop back for this event is i can't trap the address of the changing cell. Is there any way i can trap the address of the changing cell value which has formula defined in it???? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
cell value change event | Excel Worksheet Functions | |||
Cell Change Event | Excel Programming | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Cell Change Event | Excel Programming |