That's what I suspected but the people on this thread have come up with solutions to problems I thought were unsolveable.

The Function Argument Window is such a nice little feature. It gives you the answer as you go along. In our application, the last few parameters are optional and further refine the answer. For example, if you leave out the last few parameters it might show National sales, but then if you specify the State, you would get the State sales, and if you specify Region you get the Regional sales. That's not exactly what ours does but the feature lets the user confirm that they're entering valid data as they go along and before they hit enter and get #VALUE!.

Also, you don't have to enter quotes around strings and cell references are easy to work with. I suspect I would have a hard time duplicating all that with my own function argument screen but maybe I'll take a shot at it some day.

The users are trained to scroll down to get at the last parameters but it's just not as nice as having them all in view.

Thanks for the reply!