View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default loop variable range

Oops... I misread the question...
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

That adds cells in rows 3 and 5, not 3, 4 and 5.
--
HTH...

Jim Thomlinson


"Patrick Molloy" wrote:

for cl = 5 to 20 'whatever S is

if ( cells(3,cl) + cells(5,cl) ) cells(1,cl) then
'do something
next


"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