Can You Get Row/Col Info Using FOR EACH Loop?

[CaliKidd]

I read on another site that one way you can speed up code is as follows:

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

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?

 

[CaliKidd]

OK, I figured it out. I would use myCell.Row or myCell.Column to get the corresponding valued needed.

CLOSED.