Thanks Bob

Terry

"Bob Phillips" wrote:

Sometimes you have to, sometimes it is more convenient.

Say you are looping through rows, and you are using a numeric variable to
track the row number. If you want to use that in a formula, it is easier to
use R1C1 notation where the column is numeric, not a column letter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Helpme Please" wrote in message
...
Could anyone briefly tell me why you would use a R1C1 Ref please