You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Victor Delta" wrote in message
...
"T. Valko" wrote in message
...
Presumably the '&' in the formula is providing
the concatenate function?

Yes

B6 = AE (column designation)

We have the column now we need to include a row number to make it a valid
cell reference.

=INDIRECT(B6&1) =
=AE & row_number
=AE1

You might think that you could simply do this:

=B6&1

But if you tried that you found out Excel won't accept that as a valid
cell ref.. It's just a TEXT string. That's where the INDIRECT function
comes into play. It converts *TEXT representations* of references into
valid references.

Biff

Many thanks for the helpful explanation. I've learned something!

V