display edit | fill series dialog box
 

I want to create a macro where I display the EDIT | Fill |
Series dialog box. I don't want to do anything more than
that. Does anyone know how I can do that?

I am using XL 2002.

Thank you for your help.

Perry

display edit | fill series dialog box
 

Application.Dialogs(xlDialogDataSeries).Show

--
HTH,
Dianne Butterworth

Perry Kew wrote:
I want to create a macro where I display the EDIT | Fill |
Series dialog box. I don't want to do anything more than
that. Does anyone know how I can do that?

I am using XL 2002.

Thank you for your help.

Perry

display edit | fill series dialog box
 

Perry

Try

Application.CommandBars.FindControl(, 870).Execute

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Perry Kew" wrote in message
...
I want to create a macro where I display the EDIT | Fill |
Series dialog box. I don't want to do anything more than
that. Does anyone know how I can do that?

I am using XL 2002.

Thank you for your help.

Perry

display edit | fill series dialog box
 

Thank you very much for your help.

-----Original Message-----
Application.Dialogs(xlDialogDataSeries).Show

--
HTH,
Dianne Butterworth

Perry Kew wrote:
I want to create a macro where I display the EDIT |
Fill |
Series dialog box. I don't want to do anything more than
that. Does anyone know how I can do that?

I am using XL 2002.

Thank you for your help.

Perry


.