Cell sequencing by For Each .. Next Loop

[avveerkar]

1) I have a range of multiple cells defined. When I step through the cells with For Each..Next Loop I can note down the sequence number of any cell. Later on to address that particular cell, is there any way to locate the cell by only giving the Range Name and the sequence number? Only way I know to address the cell is to run the loop again, stop at the desired sequence number, get the absolute row and column addresses of the cell and then work on the cell. Not very elegant I think. Any better idea? eg if I want to address the third cell in the range named TEST if I could just use Cells(TEST,3) it would be great!!

2) I have a bigger region ( 9x9 ) cells, made up of 9 sub-regions of 3x3 cells. Can I use For Each .. Next Loop on the bigger region to step through its sub-regions instead of stepping through its cells?

A V Veerkar

[Bob Phillips]

1) Just save that range in a variable

2)

Please Login or Register  to view this content.