Thread: Variable Cell Refs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Craig[_15_] Craig[_15_] is offline
external usenet poster
  
Posts: 5
Default Variable Cell Refs
How can I change the cell ref of a formula to one that is stored in another
cell?
e.g. I want to do a

COUNTIF(B1:B*x*,"0")

where the value of *x* has been manually input in A1

TIA
Craig


Reply With QuoteReply With Quote