Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ed
 
Posts: n/a
Default Is there a macro which adds selected/highlighted cells?

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:



Thank you for your time and attention.

Yours Sincerely,

Ed
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

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

"Ed" wrote in message
...
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:



Thank you for your time and attention.

Yours Sincerely,

Ed



  #3   Report Post  
Lenny
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with macro looping and color query function kevinm Excel Discussion (Misc queries) 10 May 26th 05 01:25 AM
Looping Macro That adds a blank row between different part #'s fiero84 Excel Discussion (Misc queries) 5 March 25th 05 07:59 AM
Playing a macro from another workbook Jim Excel Discussion (Misc queries) 1 February 23rd 05 11:12 PM
Date macro Hiking Excel Discussion (Misc queries) 9 February 3rd 05 01:40 AM
Macro and If Statement SATB Excel Discussion (Misc queries) 2 December 3rd 04 05:46 PM


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"