Formula r1c1

[raymondemn]

Hi Guys

Please help me to this code

ActiveCell.FormulaR1C1 = "='Common Costs!RC[6]"

instead of common cost sheet what code should I put if the next sheet is the destination of formula.

 

[Joe4]

Welcome to the Board!

Try this:

    ActiveCell.FormulaR1C1 = "='" & Sheets(ActiveSheet.Index + 1).Name & "'!RC[6]"