Open Dialog Box Paste Special
 

How can you open the Paste Special dialog box and the Format Cells dialog box
by code?

Thank you,

Steven

Open Dialog Box Paste Special
 

Syntax is:

Application.Dialogs(<xlDialogsConstant).Show

There is a list of the xlDialogsConstants in the VBA help files which you
can acces through the VB editor window.

"Steven" wrote:

How can you open the Paste Special dialog box and the Format Cells dialog box
by code?

Thank you,

Steven

Open Dialog Box Paste Special
 

hi
in vb help type......built in dialog list....
258 of them.
wow!

Regards
FSt1

"Steven" wrote:

How can you open the Paste Special dialog box and the Format Cells dialog box
by code?

Thank you,

Steven