Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 113151 - Last Review: January 18, 2007 - Revision: 3.1
PRJ: Running Recorded Macro That Selects Fields Causes Error
This article was previously published under Q113151
SYMPTOMS
In Microsoft Project, when you record a macro that selects fields in a table in your project, and you have selected the
Relative Row References option in the
Record Macro dialog box, you may receive the following error message when you run the macro:
Run time Error '1004':
Command could not be completed successfully
-or-
Run-time error '1004':
An unexpected error occured with the method.
Check the syntax of your macro, and then try again.
CAUSE
When you record a macro that selects fields in a table, and you select the
Relative Row References option in the
Record Macro dialog box (the default setting), the upper left field in a selection is always considered to be the current selection. For example, if you turn the macro recorder on and select a field in row 10, and select a range up to row 1, the recorded command considers the first field in row 1 to be the active selection, though the active selection is actually a field in row 10. When you select from row 1 to row 10, the same command is recorded as when you select from row 10 to row 1.
When you have the
Relative Row References option selected, this behavior causes a problem because any selection you make in a table is relative to the active selection.
WORKAROUND
To avoid this problem when you are recording a macro that selects fields in
a table, do either of the following:
- Select the Absolute (ID) Row References option in the
Record Macro dialog box.
-or-
- Always select fields in the table starting from the upper left field
you want included in the selection.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
REFERENCES
For more information about the
SelectTaskField Method, choose the
Search button in
Help and type:
SelectTaskField
APPLIES TO
- Microsoft Project 2000 Standard Edition
- Microsoft Project 98 Standard Edition
- Microsoft Project 4.1 Standard Edition
- Microsoft Project 4.1a
- Microsoft Project 4.0 Standard Edition
- Microsoft Project 4.0 for Macintosh
| kbbug kbmacro kbpending kbusage KB113151 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please