Comparing 2 Rows By Looping Through Cells

[axegrynder]

I've uploaded my code with an example database.

The macro is supposed to generate a report on what has changed between the "Current" and "Previous" sheets.

The first step is to compare Current to Previous by the reference column and determine if there were any new records added. If so those records are copied to the "Report Comparison" sheet and highlighted yellow. This seems to be working.

The second step is to compare Previous to Current and determine if there were any records that were deleted. If so those are copied to "Report Comparison" and highlighted green. This seems to be working also.

Next the macro is to compare each record cell by cell, and if there is a particular cell that has been changed in a record, the entire row from Current is copied to "Report Comparison", but only the cell that changed is highlighted yellow and a comment is added to that cell showing what the previous value was( adding the comment has not been attempted in the code yet).

The last section of the code is commented out for now, but I had started by looping the cells in one specific row to see if the code was correct before trying to also loop through all the rows. If I include this code the results aren't correct. All the rows from Current and Previous are getting copied to the report. I'm not sure where the code is wrong.

Any help is appreciated. Thanks