| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing cells on a different sheet
Hi all,
I am using the following VBA to sum several discontiguous cells from Sheet 1, and placing the total on Sheet 2. Is there a more efficient way of doing this without getting too into coding? I am not a strong coder adn want to avoid it if I can. Range("E10").Value = Worksheets("Actual vs Budget").Range("C36") + Worksheets("Actual vs Budget").Range("E36") + Worksheets("Actual vs Budget").Range("G36") + Worksheets("Actual vs Budget").Range("i36") -- Carlee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing 2 columns cells into a 3rd colums cells | Excel Discussion (Misc queries) | |||
| summing 3 worksheets on a total sheet | Excel Discussion (Misc queries) | |||
| Summing values from an undetermined number of sheet | Excel Worksheet Functions | |||
| Finding cells and summing variable cells | Excel Programming | |||
Threaded Mode
