I've inherited a spreadsheet with a macro that needs to be updated. We are
moving data from one spreadsheet to another using this:
ws.Cells(i, 4) = aLine(3)
ws.Cells(i, 5) = aLine(4)
ws.Cells(i, 6) = aLine(6)
ws.Cells(i, 7) = aLine(7)

All I need to do is update the numbers and it works correctly. But when I go
into that spreadsheet the next day, the number have reverted back to the
originals. Any ideas??? I confirmed that the file was saved and it appeared
to work correctly when it was copied over for another department to access.
Any help would be greatly appreciated!
--
Mary