For Each loop on each cell in a range

[chris-evans]

I need to do a for each loop - looping through each cell within a range. How can I do this?

Thanks

Chris

 

[Russell Hauf]

On 2002-02-26 07:42, chris-evans wrote:
I need to do a for each loop - looping through each cell within a range. How can I do this?

Thanks

Chris

Dim cl as Range
For Each cl in MyRange
' do something
Next

Hope this helps,

Russell