I recorded a macro and everything worked out fine. However, a sheet in my
workbook that was linked to the sheet in which the Macro was run is having
some issues. The formatting changed to something in the custom options and
now it will not calculate simple equations. If a subtract two numbers in
which data is being extracted from it will show 0. Even though the differece
may be 100. I changed the formatting of all the cells in the macro sheet and
the linked sheet to "number" format. This did not solve the problem. But if I
typed over the linked cells then hit "undo" the calculation then works and is
correct, the 100 will display. BUT if I change a number the calculating cell
does not change. It remains 100 though it should be saying 200. ANY
SUGGESTIONS? COULD IT BE SOMETHING IN THE RECORDING OF THE MACRO? PLEASE
HELP..SOON..