View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
igorek igorek is offline
external usenet poster
 
Posts: 38
Default R1C1 formula question

I want to create a formula that will at cell R1C1. However, the C1 part needs
to be variable. Here is the example of what i think it should be:

=R1C" & B2 & "

this formula needs to return Row1 and column number whosw the value located
in the cell B2. Lets say B2 has a number 70 in it. The result of the formula
i need to return is the value located in R1C70

Please help, because my brains are exploding