Use spinner to set a cell reference in a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

a - 26 Jan 2006 16:39 GMT

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

Reply to this Message

Cutter - 26 Jan 2006 16:53 GMT

In B10 you could use:

=INDIRECT("A"&A5)

A5 would be the cell that the spinner is linked to

Signature

Cutter

Reply to this Message

a - 26 Jan 2006 18:06 GMT

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

Paul

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

> In B10 you could use:
>
> =INDIRECT("A"&A5)
>
> A5 would be the cell that the spinner is linked to

Reply to this Message

Cutter - 26 Jan 2006 21:34 GMT

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

Signature

Cutter

Reply to this Message

Dave Peterson - 26 Jan 2006 16:58 GMT

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)

> Is it possible to use the spinner to set the numeric portion of a cell
> reference, eg the 21 in the cell range "A21"?
[quoted text clipped - 9 lines]
> Thanks,
> Paul

Signature

Dave Peterson

Reply to this Message