Open Dialog Box Paste Special

S

Steven

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

Thank you,

Steven
 
J

JLGWhiz

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