View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
steveylevi steveylevi is offline
external usenet poster
 
Posts: 1
Default Use text in formula as a cell reference

I want to reference the results of a user-input cell number into a formula.

For example, in cell A1, user manually types in "B2".

I need the formula to use that variable (i.e., B2) =sum(b2:b10)