Is there a macro which adds selected/highlighted cells?

[Guest]

Dear Reader,

I'm trying to create a macro in Excel (for windows XP) which adds a certain
number of selected cells, for example 7 in a vertical direction, to a
selection of cells which are already highlighted before the button was
pressed. If there is no way using macros, then please could you offer me a
solution within another program?

Please note, I'm very new to coding/programming and understand very little
of the te technical jargon. I have read through the help files for all of
excel and all of visual basic, but find no solution directly. Please could
you take the time to go through any ideas you have with me by E-mail or other
contact as I am in great need of completing my project as soon as is possible.

Please note that my E-mail address has changed to:

(e-mail address removed)

Thank you for your time and attention.

Yours Sincerely,

Ed

 

[Anne Troy]

If you want a macro, then I suggest you offer up a better explanation,
including an example using cell references and everything. I don't
understand what you want, so likely others won't either.
************
Anne Troy
www.OfficeArticles.com

 

[Lenny]

Excel Automatically adds cells as you highlight them without any
Formulas or Macros.

Highlight a few cells and look at the bottom of the screen. you should
see the word SUM and the value. If you right click on the word Sum you
can see the other options, Average, Max, Min, etc.

Lenny