Oxy,
Try entering the following in cell C3:
=INDIRECT("A"& TEXT(1+B2,0))
HTH
Tim
"oxymoron" wrote in message
...
VBA is new to me, and I would like to know if I - either directly in
Excel or in VBA - can do arithmic within the cell address itself. Can I
in any way do something like this: write A(1+B2) in C3 and make it
work? If B2=3 and A4=2 then C3 shuold end up beeing 2 ...
What if I use the R1C1 approach?
Any help appreciated
Message posted from http://www.ExcelForum.com/