Use spinner to set a cell reference in a formula
 

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

Use spinner to set a cell reference in a formula
 

In B10 you could use:

=INDIRECT("A"&A5)

A5 would be the cell that the spinner is linked to


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=505377

Use spinner to set a cell reference in a formula
 

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)


a wrote:

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

--

Dave Peterson

Use spinner to set a cell reference in a formula
 

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

Paul

------------------------------------------------------------------------

"Cutter" wrote:


In B10 you could use:

=INDIRECT("A"&A5)

A5 would be the cell that the spinner is linked to


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=505377

Use spinner to set a cell reference in a formula
 

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=505377