Microsoft KB Archive/125913

= 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.