Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have to run totals on many rows/columns. I started a little macro, but would like to learn how to loop thru this data. Please explain as you go, so I can learn rather than just copy your excellent code :-) 'Calculate Totals for every 15th row (3 in sample, 8 rows total) Range("C2").Select ActiveCell.FormulaR1C1 = "=SUM(R17C3,R32C3,R47C3,R63C3)" Range("C3").Select ActiveCell.FormulaR1C1 = "=SUM(R18C3,R33C3,R48C3,R64C3)" Range("C4").Select ActiveCell.FormulaR1C1 = "=SUM(R19C3,R34C3,R49C3,R65C3)" 'Move to next Column and calculate (2 in sample, 6 columns total) Range("D2").Select ActiveCell.FormulaR1C1 = "=SUM(R17C4,R32C4,R47C4,R63C4)" Range("D3").Select ActiveCell.FormulaR1C1 = "=SUM(R18C4,R33C4,R48C4,R64C4)" Range("D4").Select ActiveCell.FormulaR1C1 = "=SUM(R19C4,R34C4,R49C4,R65C4)" Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
returning back to loop check condition without completing the loop | Excel Programming | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming |