All cells are formatted as "General". Range(Cells(1, 1), Cells(5, 5)) all contain a 2. Getting type mismatch error - see "Watch" at bottom.
Declared in a module:
Option Explicit
Public OldData As Variant
Public Newdata As Variant
Public TmpData As Variant
Worksheet:
Option Explicit Private...