Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Calgary, Alberta, Canada
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ShowDependents (97 SR-2)

    Sub RangeP()
    Application.ScreenUpdating = False
    For Each x In Selection
    On Error Resume Next
    If x.Value <> "" Then
    x.ShowPrecedents
    End If
    Next
    Application.ScreenUpdating = True
    End Sub

    The above code works through a selected range and displays the precedents for each cell. I have written this to save the manual interactions using the auditing toolbar.

    I would like to have a similar piece of code for ShowDependents, however, I cannot get past it erroring because "ShowDependents method of Range class failed". I get this error even if I extract the text from the example given in the help file for ShowDependents (ActiveCell.ShowDependents) and run that.

    Can anyone shed any light on how to get over this hurdle?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: ShowDependents (97 SR-2)

    This is a bug in XL97. There is a workaround published here.

    Steve

  3. #3
    Lounger
    Join Date
    Nov 2001
    Location
    Calgary, Alberta, Canada
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ShowDependents (97 SR-2)

    Thanks Steve that has done it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •