Although this is simple task i stuck up with these
for eg. cell A1= 5 (variable), A5=10 and i need in
in cell b1= A(variable of a1) in this case it is A5 i.e 10
How to write formula or macro for this.

On May 5, 8:46*am, ezil wrote:
Although this is simple task i stuck up with these
for eg. cell A1= 5 (variable), A5=10 *and i need in
in cell b1= A(variable of a1) * * * * * in this case it is A5 i.e 10
How to write formula or macro for this.

Take a look at the INDIRECT function.

B1 = INDIRECT("A" & A1)

Chris M.