No VBA methods support linked cells to other sheets (that I am aware of).
Stephen Bullen used the Excel4 commands associated with the dependency
arrows to solve this problem. You can check out his utility to resolve
circular error references where the code is open to inspection.

http://www.BMSLTD.ie

On the left is a link to his excel page.

--
Regards,
Tom Ogilvy

"Pratik Mehta" wrote in message
...
Friends,

I am using Excel VBA to keep track of depedent cells.

In a certain scenario, if any cell is getting changed and
it is having any depedent cells, I want to set focus to
that depedent cells. I am using Change event to achieve
the same functionality. Code snippet is like below:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo errHandler:
Target.Dependents.Activate
Exit Sub
errHandler:
Application.StatusBar = Err.Description
End Sub

It works fine if depedent cells are in the same sheet.
But, if depedent cell is in other sheet and/or workbook.
It is not working and giving error like "No Cells were
found"!.

Please guide me how can I do that?