Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculated Column Using Loop
How do you calculate a column using a loop?
A B C 1 100 200 ? 2 13 17 ? .. .. .. N |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculated Column Using Loop
Perhaps you can give a better explanation? Is this homework?
-- Don Guillett SalesAid Software wrote in message oups.com... How do you calculate a column using a loop? A B C 1 100 200 ? 2 13 17 ? . . . N |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculated Column Using Loop
Sub CalcColumn()
Dim cell as Range Dim rng as Range set rng = range(cells(1,2),cells(1,2).End(xldown)) for each cell in rng cell.offset(0,1).Value = cell.Value + cell.offset(0,-1).Value Next End Sub -- Regards, Tom Ogilvy " wrote: How do you calculate a column using a loop? A B C 1 100 200 ? 2 13 17 ? .. .. .. N |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculated Column Using Loop
What answer would you like to have in C?
" wrote: How do you calculate a column using a loop? A B C 1 100 200 ? 2 13 17 ? .. .. .. N |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increasing the number calculated by for same column | Excel Discussion (Misc queries) | |||
Sumproduct with calculated column | Excel Programming | |||
Loop through column headers to search from column name and get cell range | Excel Programming | |||
Can the sum of 1p + 3p be calculated in a column in Excel? | Excel Discussion (Misc queries) | |||
using a calculated column value within a range | Excel Programming |