diffCount = 0
' Assume same dimensions Set rng1 = ws1.UsedRange Set rng2 = ws2.UsedRange excel compare two sheets for differences
To check if entire row exists: