Use spinner to set a cell reference in a formula

[Guest]

Is it possible to use the spinner to set the numeric portion of a cell
reference, eg the 21 in the cell range "A21"?

The resulting cell range, "A21", is to be used in another formula...like this:
Cell "B10" = "A21"

The tricky part has been getting the "A21" to function as a formula (=A21)
and not just as literal text "=A21").

I hope this question makes sense.

Thanks,
Paul

 

[Cutter]

In B10 you could use:

=INDIRECT("A"&A5)

A5 would be the cell that the spinner is linked to

 

[Dave Peterson]

You can assign a linked cell to that spinner--say your linked cell is x99.

Then you can use that linked cell in the formula:
=indirect("A"&x99)

 

[Guest]

Thank you both, Cutter and Dave Peterson for those nice, elegant answers.

Paul

 

[Cutter]

You're welcome. And please note that you are the first to use "Cutter"
and "elegant" in the same sentence.