Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loop variable range
I misread the question...
Dim rng As Range For Each rng In Range("D1:S1") If rng.Offset(2, 0).value + rng.Offset(4, 0).value rng.Value Then MsgBox rng.Address End If Next rng -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: One way... Dim rng As Range For Each rng In Range("D1:S1") If Application.Sum(rng.Offset(2, 0).Resize(3, 1)) rng.Value Then MsgBox rng.Address End If Next rng -- HTH... Jim Thomlinson "CR" wrote: I have a Range with values D1:S5 I need to sum D3 and D5 and if it is D1 value then Do something Then loop through E to S, doing the same thing Any help would be appreciated Thanks CR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loop variable range | Excel Programming | |||
loop variable range | Excel Programming | |||
Referencing variable Range in a loop | Excel Programming | |||
How to reference variable range in a loop | Excel Programming | |||
Setting a range within a loop variable for copy/paste | Excel Programming |