For Each loop on each cell in a range

chris-evans · Feb 26th, 2002, 08:42 AM

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

Thanks

Chris

Russell Hauf · Feb 26th, 2002, 08:46 AM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 08:42 AM	#1
chris-evans Board Regular Join Date: Feb 2002 Posts: 63	I need to do a for each loop - looping through each cell within a range. How can I do this? Thanks Chris