I'm having an issue passing the exact cell contents to a variable and sending the variable contents to a particular cell.
Example: Pass each cell contents to Var1 and then to Cell("B1")
Var1=Range("A1") 'substitute A1 for A2 and etc..
Range("B1") = Var1
The issue is with A3; B1 ends up being 1 not "'0001".