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

--
Ian
--
"ranswrt" <(E-Mail Removed)> wrote in message
news:FA843D0D-FFF3-42DD-B3BF-(E-Mail Removed)...
>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

Thanks I will give that a try

"IanC" wrote:

> 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?
>
> --
> Ian
> --
> "ranswrt" <(E-Mail Removed)> wrote in message
> news:FA843D0D-FFF3-42DD-B3BF-(E-Mail Removed)...
> >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
>
>
>