S Steven Dec 11, 2008 #1 How can you open the Paste Special dialog box and the Format Cells dialog box by code? Thank you, Steven
How can you open the Paste Special dialog box and the Format Cells dialog box by code? Thank you, Steven
J JLGWhiz Dec 11, 2008 #2 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.
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.
F FSt1 Dec 11, 2008 #3 hi in vb help type......built in dialog list.... 258 of them. wow! Regards FSt1
