![]() |
New Name Dialog parameters
I would like to programatically call the "New Name Dialog" box for a given
name. Microsoft.Office.Interop.Excel.Dialog D = ExcelApp.Dialogs[Microsoft.Office.Interop.Excel.XlBuiltInDialog.xlD ialogNewName]; D.Show(System.Reflection.Missing.Value, System.Reflection.Missing.Value ,System.Reflection.Missing.Value, System.Reflection.Missing.Value ,System.Reflection.Missing.Value, System.Reflection.Missing.Value ,System.Reflection.Missing.Value, System.Reflection.Missing.Value ,System.Reflection.Missing.Value, System.Reflection.Missing.Value .... ); Which of the many parameters to the Show() method corresponds to the [New] range name? Is there any thing I should do before passing the data in. |
All times are GMT +1. The time now is 12:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com