[Solved] Converting a string into a cell number

[clfaye]

I have a cell (example B405) that contains the name of another cell (example C32) as a string. C32 has a number in it. I would like to have a function to bring in the number from C32 using the string from B405. I have a function - but it doesn't work:

{
Function Cell_Equals(Text_From_Cell as string)

Cell_Equals = "=" + Text_From_Cell

end function
}

but all this does is plop =C32 into the new cell as a string. This is what you would type into the cell to get the value from C32, but I don't know how to stop having Calc treat it as a string.
Thanks!
Chris

[RusselB]

Welcome to the Forums.

Rather than creating your own function, this sounds like what the INDIRECT function does.

[clfaye]

Yes - that is perfect! Thanks!