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