Thread: Function Wizard
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Function Wizard

Possibly
ActiveCell.Formula = "=Sum(1)"
ActiveCell.FunctionWizard

--
Regards,
Tom Ogilvy

"Madiya" wrote in message
...
I am trying to simulate the function wizard thru a macro
which will show the function wizard for a perticuler
function. So far I have
ActiveCell.FunctionWizard which shows the screen to select
the function.

How do I make the wizard to show directly next screen with
arguments for a perticuler function (say SUM)?

Regards,
Madiya