Microsoft Knowledge Base

XL: Custom Function Pasted to Wrong Cell with Function Wizard
Last reviewed: January 7, 1997
Article ID: Q125913
The information in this article applies to:
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Macintosh, versions 5.0

SYMPTOMS

When you use the Function Wizard to paste a user-defined function in a cell, that function may be pasted in a different worksheet and cell than the one you selected.

CAUSE

This problem occurs when the function requires at least one argument and the last argument entered points to a cell on a sheet other than the active sheet. This problem occurs only when the Function Wizard is used to insert the function and you use the mouse to specify the last argument.

WORKAROUND

To insert a function that has a cell reference located on another sheet for its last argument, do one of the following:

  • Type the formula in the cell.

    -or-

  • Insert the formula with the Function Wizard. In Step 2 of the Function Wizard, do not use the mouse to click the cell locations for the last argument. Instead, manually type the reference into the argument box.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed at the beginning of this article.

This problem has been corrected in Microsoft Excel 97 for Windows.

KBCategory: kbprg kbusage kbtool
KBSubcategory: xlformula xlwiz xlvbainfo

Additional reference words: 5.00 5.00c user defined XL5



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 7, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.