HELP! Here is what I have to work with and I do not like
having to figure out if 38 cells to the left is the
column I want to work with. I would rather use the
formula the way it is in the actual spreadsheet cell (=IF
(BJ2=0,BK2,BK2/BJ2)

instead I have this:
Sheets("Data").Select
Range("CT2").Select
ActiveCell.FormulaR1C1 = "=IF(RC[-37]=0,RC[-38],RC[-38]/RC
[-37])"

This is an extensive data tab for pivot tables with 100-
7000 rows and columns A-CZ.

Any help is appreciated.