I have to compare two sheets for changes

  • Thread starter Thread starter vqthomf
  • Start date Start date
V

vqthomf

Hi I have to try and compare 2 sheets and highlight the cahnges, what is the
best way of doing this in VBA, I was going to try and do it cell by cell but
I was wondering if there was a quicker way?. Any help would be much
appreciated.
Regards
Charles
 
Maybe you can make use of conditional formatting, e.g. if you want to compare
newsheet to oldsheet which is an earlier version of newsheet, then apply CF
on newsheet! Select A1 then select used range on newsheet and create CF with
formula =A1<>oldsheet!A1
Choose a pattern and press OK!
--
Regards!
Stefi



„vqthomf†ezt írta:
 
Back
Top