XL97: Copy From Object Browser May Not Copy Named Arguments

WORKAROUND

Workaround 1

You can copy named arguments from the Object Browser. To do this, follow these steps:

1. Select the text of the item and its named arguments in the Detail section and then click Copy on the Edit menu.
2. Go to the location where you would like to paste the named arguments, and then click Paste on the Edit menu.

Workaround 2

You can use the "Auto Quick Info" feature of the Visual Basic Editor to display information about functions and their parameters as you type.

To enable "Auto Quick Info" do the following:

1. On the Tools menu, click Options.
2. Click the Editor tab.
3. Select "Auto Quick Info" and click OK.

When this feature is enabled and you type a function in the Code Window, a small information window appears beneath your line of code that indicates the syntax of the function you're typing.