Thread: Variable Cell Reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew Andrew is offline
external usenet poster
  
Posts: 1
Default Variable Cell Reference
In A1 I want to show the value of cell Cx where x is a variable held in B1
eg.

B1= 5
A1 should show the value of C5

How can I do it please/

TIA
Andy




Reply With QuoteReply With Quote