I want to display the excel builtin dialog box "subtotalcreate" and have the
"at change in", "function number", and "total" arguments preassigned values.
The user would not have to choose them from their lists, just click "ok" or
"cancel". Is there a way to do this? Please include syntax.
If this isn't possible, is it possible to replicate in VBA code what the
"subtotalcreate" dialog box does? The user would not see any dialog box at
all but the subtotaling would occur based on the assigned values that I would
use.

Thanks,
Randy