Subtotal Function

[Steven]

I would like to start the function:
=Subtotal(9,
and then have the system wait for my highlighting of the cells and then I
hit ENTER and it will accept the formula.

Is that possible?

Thank you,

Steven

 

[Bob Phillips]

Is that what happens by default?

 

[Rick Rothstein]

??? Excel works that way now (at least on my XL2003 version)... right after
you type the comma, just click/drag the range you want and then hit the
Enter key.

 

[Steven]

I want to do it in a macro and set a shortcut key so I do not actually have
to type the: =Subtotal(9,

I just want to hit the shortcut key and then highlight ....... and hit ENTER.

Thank you

 

[Rick Rothstein]

Perhaps this will suffice instead...

Dim R As Range
Set R = Application.InputBox("Select a range to subtotal..", Type:=8)
ActiveCell.Formula = "=SUBTOTAL(9," & R.Address & ")"

 

[Steven]

Thank you very much. It seems like a little thing but I am so tired of
typing =Subtotal(9,.........) and I do not like using =Sum() that much
anymore. This will save me 5 seconds each time I have to use an =Subtotal()
and will trememdous brain stress. Thanks again.