LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Macro Command Button to Sum specific cells in a range

Hello all,

I am trying to create a command button that will sum a specific cell to a
"total" cell located beneath it. For instance, I will have numbers ranging
from B3 all the way to CB3 and want the values in these cells to be added to
the corresponding cells in, say, B16 through CB16. Therefore, whatever is in
cell B3 will be added to cell B16 and that will be the new value in cell B16,
and so on. I would like to make this dynamic, as the data may extend past
column CB. Also, I will have other data to add in rows 4 through 12.

Currently, I am doing this very inefficiently by summing each cell, so the
code is very repetitive and long. Any suggestions?
 
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
modify a macro to apply to a specific range of cells Dave F Excel Discussion (Misc queries) 2 April 25th 07 03:00 AM
Macro to Specific Cells in a Range Magnivy Excel Programming 4 April 24th 06 05:57 PM
Macro to Select Specific Cells in a Range Magnivy Excel Programming 1 April 24th 06 05:18 PM
command button that puts specific numbers in a range of cells ko6ad Excel Programming 2 February 28th 06 05:41 PM
command button to move user to specific spot on different sheet grime[_9_] Excel Programming 7 January 13th 06 07:21 PM


All times are GMT +1. The time now is 07:49 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"