Changed cell value not recognized

[BDBatBear]

WinXP - Excel 2003

I have the following sub-routine on a sheet to capture when a user changes the value in a range of cells:

Private Sub Worksheet_Change(ByVal Target As Range)
End Sub

For most users, the value of Target is the new value they have just entered into the cell. Thus, there is no problem.

However, for one of the users, the value of Target retains the value of the cell before the change is made. When I stop the debugger inside of this sub-routine and look at the worksheet, I do see the new version, but a debug.print of Target displays the old value.

Does anyone have any ideas about this?

Thanks,

- Bruce

 

[stanleydgromjr]

Can we see all the code between the following two lines?

Private Sub Worksheet_Change(ByVal Target As Range)
End Sub


Have a great day,
Stan

 

[BDBatBear]

The code is not relevant. I have a debug.print line and I manually print the values of Target (both value and address). The only difference is that the output in the problem computer is the initial cell value and on mine (and others) the new cell value.