What exactly are you trying to do with this? It may be able to be done
another way.

Barb Reinhardt



"Ted M H" wrote:

I'm trying to find the code to display the Paste Names dialog box. You can
usually get this to pop up with F3 when working in the standard user
interface in Windows versions of Excel.

I've tried the following code, which works just fine for some built in
dialog boxes, but errors out for Paste names:

Application.Dialogs(xlDialogPasteNames).Show

This statement results in the RunTime 1004 message.

If I change this to application.Dialogs(xlDialogDefineName).Show the Define
names dialog box pops right up.

Any ideas?