Moving between "row" and "range" formats in VBA

[kls]

In general, I need to know; if I come upon a certain row, using the
Range-Cells technique, perhaps in a loop, having arrived there, is there
a way to activate the whole row?

(I'm trying to learn how to move back and forth between these two types
of ways of identifying and altering either a range or an entire row or
colummn)

Thanks



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Tom Ogilvy]

cells(i,5).entireRow

rows(3).Cells(1,1).Offset(0,4)

From the immediate window:

i = 6
? cells(i,5).entireRow.Address
$6:$6

? rows(i).Cells(1,1).Offset(0,4).Address
$E$6