View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
A A is offline
external usenet poster
 
Posts: 37
Default 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