Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Looping Macro That adds a blank row between different part #'s | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |