I have a VBA Macro that takes data from one spreadsheet to another. In
the new sheet there is a little formatting and some sorting. When the
Macro ends it seems as though the program stops on a specific cell. In
thetask Bar it shows this: Sum = 38565. What should really be in the
Cell is Aug-05 as a date. I've tried formatting the from Cell to
"General" and to "Date", but these don't seem to work. Can anyone help?