ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   loop variable range (https://www.excelbanter.com/excel-programming/433891-re-loop-variable-range.html)

Jim Thomlinson

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





All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com