Knowledge Base

XL97: Run-Time Error Using ShowDependents Method

Article ID: 164810

Article Last Modified on 10/11/2006

Microsoft Excel 97 Standard Edition

This article was previously published under Q164810

SYMPTOMS

When you run a Visual Basic for Applications macro that uses the ShowDependents method, you may receive the following error message:

Run-time error '1004':
ShowDependents method of Range class failed

WORKAROUND

To work around this problem, use the ExecuteExcel4Macro method in your macro.

Examples

If your macro contains the following line of code to trace formula dependents

   Selection.ShowDependents

replace it with the following line of code:

   Application.ExecuteExcel4Macro "TRACER.DISPLAY(FALSE,TRUE)"

If your macro contains the following line of code to remove the arrows that trace formula dependents

   Selection.ShowDependents Remove:=True

replace it with the following line of code:

   Application.ExecuteExcel4Macro "TRACER.DISPLAY(FALSE,FALSE)"

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000.

MORE INFORMATION

REFERENCES

For more information about auditing, click Contents and Index on the Help menu, click the Index tab in Excel Help, type the following text

auditing formulas, tracing dependents and precedents

and then double-click the selected text to go to the "About examining the structure of formulas" topic. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: XL97 xlvbmigrate

Keywords: kbbug kberrmsg kbprogramming KB164810