PDA

View Full Version : Solved: Iterate through columns



gscarter
07-28-2008, 02:26 AM
Hi,

I wish to iterate through each column on row 1, for example A1, B1, C1 etc.

Is there a simple way to do this?

Thanks
Gary

Bob Phillips
07-28-2008, 03:05 AM
For i = 1 To 3
With Cells(1,i)
'do something
End With
Next i