I'm trying to set my active cell to equal B34. But when I do it, the formula
is in R1C1 format. Next time the macro runs, B34 will be in a different
position relative to my active cell. What should the code look like if I
want ActiveCell.Formula = B34???