Excel - Sum Function 1

[DSerr77]

I use the sum function endlessly and I want to create a keyboard shortcut to insert the sum function. However, when I write a macro to do so it does not auto select the range. Does anyone know how I can write a macro to insert the sum function and auto identify the correct range. Thanks for any suggestions.

 

[SkipVought]

Hi,

Why don't you use the AutoSum Icon on the toolbar?

Otherwisw, past this in a MODULE

Sub MyAutoSum()
   With ActiveSheet.UsedRange
      ActiveCell.Formula = "=SUM(" & Range(Cells(.Row, ActiveCell.Column), Cells(ActiveCell.Row - 1, ActiveCell.Column)).Address(False, False) & ")"
   End With
End Sub

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[AnotherHiggins]

There already is a keyboard shortcut for AutoSum.

<ALT>+<=> will do the same thing, along with autoselecting the range!


John

Every generalization is false, including this one.

 

[SkipVought]

John,

Kudos! For some reason, Keyboard Shortcuts were/are never high on my list. ==> *

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[AnotherHiggins]

Thanks, Skip!

I am a lazy, lazy man. Anytime I can use a keyboard shortcut rather than going *all* the way over to my mouse, I'll do it.

John

Every generalization is false, including this one.

 

[MSIsam]

A good reference sheet for Excel shortcuts:

http://www.fgcu.edu/support/office2000/excel/shortcuts.html

 

[KenWright]

One they don't have listed on selecting cells is CTRL+* which selects the Current Region.

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------