I'm writing a macro where i'm putting 2 cells that are separated by a space on sheet2.
I can recreate it except for the space in between the 2 cell references.
ActiveCell.FormulaR1C1 = "='shee1'!RC & "" "" & 'sheet1'!RC"
How can i write the above in a vba module? Thank you for the help.