J
Jim May
Someone provided me the answer to a problem I had.
They used the above in conjunction with the Right( ,)
Function. Actually the entire formula I inserted into the
refers to box of a range name. Then I used the funtion
=INDIRECT("Sheet2!J"&ref) << where ref is my range name.
Right now I'm a bit confused as I can't seem to find
anything, anywhere on this GET.CELL(6,A20) usage.
Can someone direct me to where I can get more info on this?
TIA,
JM
They used the above in conjunction with the Right( ,)
Function. Actually the entire formula I inserted into the
refers to box of a range name. Then I used the funtion
=INDIRECT("Sheet2!J"&ref) << where ref is my range name.
Right now I'm a bit confused as I can't seem to find
anything, anywhere on this GET.CELL(6,A20) usage.
Can someone direct me to where I can get more info on this?
TIA,
JM