Quote Originally Posted by arnelgp View Post
can you use:

Range("C2:C601").FormulaR1C1 ="='340 nm'!RC-'340 nm'!C[3]"
Thank you for the suggestion. It seems to work partially now. I have a huge field of data from which I have to substract the backgroun in the "340 nm" tab from the "C" column. It does work if I use your suggestion as:

Range("C2:C601").FormulaR1C1 = "='340 nm'!RC-'340 nm'!C[0]"
Range("D2:D601").FormulaR1C1 = "='340 nm'!RC-'340 nm'!C[-1]"

The only problem now is that I basically have to repeat this function for each column. Is there a better way to do this? If I use the following I strike the whole field, but I always substract from the same column as the original data comes from, not the "C" column:

Range("C2:HZ601").FormulaR1C1 = "='340 nm'!RC-'340 nm'!C[0]"

I'm basically looking for a way to fix the "[0]" part to that specific column.

Thanks in advance for the help!