Why does this work?
This works correctly
With Sheets("Running total")
LastRow = .Cells(.Rows.Count, "B").End(xlUp).Row
.Cells(LastRow, "B").Resize(1, 28).Copy .Cells(LastRow + 1, "B")
.Cells(LastRow, "B").Resize(1, 28).Value = .Cells(LastRow,
"B").Resize(1, 28).Value
End With
Why do I need the resize (1, 28) twice on the last line to change the
equations to values? But on the second line - I don't need it.
Confused - can someone shed some light on the subject. Or if there is a
better way to range value - please let me know.
|