Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you are working with (changing) only cells with numeric, you can make a
copy of your original sheet to another sheet in the workbook which contains ONLY VALUES from your original sheet. In a third sheet, in every cell, just have a formula that subtracts the cell value of the original sheet from the respective cell value of the updated sheet. Any cells that are now not equal to 0 in your third sheet, you know have changed. "scottydel" wrote: Hello, I'm using Excel 2003. The woksheet change event fires when any data on the worksheet changes. Does anyone know a way to determine which specifc cell (or range I suppose) has changed? Thanks, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Quick VBA Worksheet Change Event or Selection Question: | Excel Worksheet Functions | |||
Event Change Question | Excel Programming | |||
Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |