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????