I read on another site that one way you can speed up code is as follows:
In the first example, i is the column number, but how can you get the cell address or column when using the For Each loop?
Rich (BB code):
mProduct = 1 For i = 5 to 10 mProduct = mProduct * Cells(3,i) Next Use 'For Each' rather than 'indexed For': We can avoid using Indexed For when looping through collections. For example, take the code just before this tip. It can be modified to: For Each myCell in Range("C5:C10") mProduct = mProduct * myCell.Value Next