I've got a weird one here folks. I have a simple workbook that
keeps track of certain files on the computer by recording the
location of the file, and the date and time the file was last
modified. I have a VBA function in a cell that determines the
correct modification date of the file by using the data in 2 other
cells (PATH and FILENAME) respectively. Works great in the original
column. Yet, when I try to copy the working cell from one column to
another, the results of the formula(function) do not appear in the
target cell. The formula appears, but it will not calculate and
display the result. I've tried many things to fix this:

1. recalculate all formulas
2. check to ensure that target column/cell is not locked
3. save workbook, close and reopen
4. type formula with VBA and source cell references by hand
5. I forget what else.

Using Excel in Office 2003. Any ideas?