forgotten object
 

Private Sub Worksheet_Change(ByVal Datarget As Range)
Datarget.Font.ColorIndex = 5
End Sub
=====================
Hi

At one time, I must have gotten this code in the VBAProject | Microsoft
Excel Objects | This Workbook.

I'm trying to figure where I can find Datarget.

Please advise.
Thanks
Steve

forgotten object
 

Steve,

This line of code might work and tell you the sheet that the range is on.

msgbox Datarget.parent.name

hth,

Doug

"SP" wrote in message
...
Private Sub Worksheet_Change(ByVal Datarget As Range)
Datarget.Font.ColorIndex = 5
End Sub
=====================
Hi

At one time, I must have gotten this code in the VBAProject | Microsoft
Excel Objects | This Workbook.

I'm trying to figure where I can find Datarget.

Please advise.
Thanks
Steve