Having been pointed at this command im having a little problem that you may be able to help me out with.
I have a formula in a cell part of which is
=INDIRECT((CHAR(CODE(B1)+1))&A6-1)
Where B1 is the column letter and A6 is the row number. Although probably very inelegant it does what I want it to up to row Z, after this it understandably goes awry. I cant seem to get the formula to work in the Excel R1C1 set up.(This might be because I use it so infrequently and dont understand it that well). Any help appreciated.
Thanks
John
I have a formula in a cell part of which is
=INDIRECT((CHAR(CODE(B1)+1))&A6-1)
Where B1 is the column letter and A6 is the row number. Although probably very inelegant it does what I want it to up to row Z, after this it understandably goes awry. I cant seem to get the formula to work in the Excel R1C1 set up.(This might be because I use it so infrequently and dont understand it that well). Any help appreciated.
Thanks
John