Compare Ranges

[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

 

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

 

[ranswrt]

Thanks I will give that a try

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?