vba - format
 

I know i have the wrong format, but i've tried numerous differen
formats and cannot get this to work.. I know that if you have a loo
and want different rows this is the format:

set rng= worksheets(1).Range("D" & J+K, "N" & J+K)

but, now what if i want to cycle through a known number of rows, bu
from one column to the next?

i had figured something like this:


for each I =4 to 10 ' columns D thru J
'rows 5 to 20
set rng=worksheets(1).Range(& I "5", & I "20")

'do stuff
next I
like i said, i've tried setting it up many different ways, but i jus
havent found the right format yet.. am i close?
Can anyone tell me what is correct!
thank you in advance

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

vba - format
 

For Each cell In Range("d5:j20")
'do stuff
Next Cell


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

vba - format
 

but i want it to then go to column E then F etc etc.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

vba - format
 

for icol = 4 to 10
for irow = 5 to 20
set rng = worksheets(1).Cells(irow,icol)
' work with rng
Next irow
Next icol

--
Regards,
Tom Ogilvy



chick-racer wrote in message
...

but i want it to then go to column E then F etc etc.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

vba - format
 

For mudraker's solution

Dim col as Range
Dim rw as Range
Dim rng as Range
For Each col In Worksheets(1).Range("d5:j20").Columns
for each rw in col.Cells
set rng = rw
'do stuff
Next rw
Next col


I am assuming you want to do rows 5 to 20 in column d, then do rows 5 to 20
in column E and so forth, one cell at at time.



--
Regards,
Tom Ogilvy


chick-racer wrote in message
...

but i want it to then go to column E then F etc etc.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/