Compare Ranges

R

ranswrt

I have a sheet that is updated when it is activated. Is there a way to check
if any or the ranges have been changed when it is updated and to identify the
ranges that have been changed?
Thanks
 
I

IanC

I'm not certain of the exact details, but how about a routine using the
Workbook_BeforeClose to copy the ranges (paste values) to another location
(another, possibly hidden, sheet) within the workbook, then another routine
to compare these values with the current values after opening?
 
R

ranswrt

Thanks I will give that a try

IanC said:
I'm not certain of the exact details, but how about a routine using the
Workbook_BeforeClose to copy the ranges (paste values) to another location
(another, possibly hidden, sheet) within the workbook, then another routine
to compare these values with the current values after opening?
Click to expand...
 
Top