Take a look at the Indirect function.
--
HTH...

Jim Thomlinson


"Tigerxxx" wrote:

Hello,

Is it possible for me to make the column as well as the row portion of a
reference cell variable?
Example- If the reference is to cell B4, can I make "B" as a variable using
a formula as well as make "4" as a variable using a formula?

Please advise.
Thank you.