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/