Results 1 to 1 of 1
2002-04-12, 05:57 #1
- Join Date
- Mar 2002
- Thanked 0 Times in 0 Posts
Finding XL off-sheet feeds (VBA 5 / XL 2k)
XL 95 / 98 was unable to navigate / identify off-sheet feeds via code. Auditing arrows could be displayed using:
Trying to use .NavigateArrow ([Toward Precendent = ]True) to follow off-sheet feed returned "Navigate Arrow method or Range Class failed"
Does anyone know if off-sheet feeds can be traced directly in XL 2K (he asks hopefully)? If so, has anyone seen code to return cells containing references to other sheets / workbooks? Have tried following code without success:
Function FeedsOffsheet(TargetCell as Range, CurrentSheetName as String) as Boolean
Dim Precedents As Range
Set Precedents = TargetCell.DirectPrecedents
Dim Cell as Range
For Each Cell In Precedents
If Cell.Worksheet.Name = CurrentSheetName Then
FeedsOffsheet = True
If run over a cell containing only off-sheet feeds the error "No cells found" is returned.
Obviously, could count errors arising when using .NavigateArrow. But method can fail for a range of reasons. Code is also slow.