VBA for Excel

[skong]

Hi,
I am trying to use a variable to set the relative position in my formula, but it seems this is not right. Can this be done? If not, is there any other way to do this? I will need to paste the formula for the entire row after this.

For normalCounter = 2 To numNormal
offsetCol = offsetCol - 3
ActiveCell.FormulaR1C1 = ActiveCell.FormulaR1C1 _
& " +(LOG10(RC[-offsetCol]))"
Next normalCounter

skong

 

[segmentationfault]

What are you trying to achieve with "RC[-offsetCol]"? Is RC a variable you have declared elsewhere?

 

[skong]

Thanks for your response. I was trying to use RC[-9] to tell Excel use the cell 9 columns to the left of the current cell. RC is Excel keyword and "offsetCol" is the variable I declared. After I posted the question, the problem was solved when a friend told me that I just mixed up variables with string.