Solved: Iterate through columns

[gscarter]

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]

[vba]

For i = 1 To 3
With Cells(1,i)
'do something
End With
Next i
[/vba]