Mon 1 Dec 2008, 16:25Delegate Maik said...
Maik has attended:
Excel VBA Intro Intermediate course
Excel VBA loops
How do I write a loop to calculate a result for each row in a spreadsheet?
Wed 21 Jan 2009, 15:37Trainer Laura said...
RE: Excel VBA loops
Hi Maik
Thank you for your question.
To work through rows of data in a loop I recommend you use the For Each loop
Example
Dim rngRow as Range
Dim rngData as Range
Set rngData=Range("A2:E44") ' Change to the correct area
For Each rngRow in rngData.Rows
'insert code to manipulate or enquire upon each row
'eg rngRow.cells(1).Interior.Color = vbRed
Next rngRow
Please let me know how you get on.
Laura GB
