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