Yes that is possible, but you may want to include two variables (row and col). There are a couple of ways to do it, but the easiest way is to use Cells. In the following, it is not exactly correct, but you get the idea. If you want the double refernce (Row and Col), then use another For lngCol 2 to 50 statement inside the one below.
Dim lngRow as Long, lngCol as Long
For lngRow 2 to 50
old, slow, and confused
but at least I'm inconsistent!