create loop for main range

[asafraz81]

hi,

i wrote a simple code that suppose to run in main range,

and inside this range i need the code to run column by culomn.

the range is between column b to i,

and i need to run first on column b after that to run on column c and ect...

in every column thecode must manipulate the cells, thats why i have loop on the cells function.

please help itsvery urgent ...

i attached the code, i know that is very simple...


Sub check1()

Dim cell As Range

Dim x As Range

Dim r As Integer

r = 2

Do Until r = 10

For Each x In Range("b3:i12")

For Each cell In Range("b3:b12")

cell = cell.Value + Cells(14, r)

Next cell

Next x

End Sub


thanks,

asaf

 

[Trader273]

Seems like it should be pretty easy, but not following 100%. Any change you could post some same data of what you want to accomplish?

 

[Trader273]

Here's what I took from your initial question:

https://www.dropbox.com/s/fmzhu5cge4ph9zj/Multiple%20Loops.xlsm


if not 100% what you are looking for, least should be a starting point.