Macro For...Next Loop - use counter in FormulaR1C1

[SkyWalker1012]

I am trying load Picking Sheets with data from another sheet. I cannot workout the syntax to access the data. Receiving Compile error - Syntax.

how do I access the other sheet?

Sub Macro4()
'
' Macro4 Macro
'

'
Dim OrderCount As Integer

For OrderCount = 0 To 600
ActiveCell.Offset(0, 1).Range("A1:A2").Select
ActiveCell.FormulaR1C1 = "='pie drive numbers'!RC[-"&OrderCount*2&"]"
ActiveCell.Offset(2, 0).Range("A1").Select
ActiveCell.FormulaR1C1 = "='pie drive numbers'!RC[-"OrderCount*2"]"
ActiveCell.Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:A23"), Type:= _
xlFillDefault
ActiveCell.Range("A1:A23").Select
ActiveCell.Offset(-2, 2).Range("A1").Select

Next OrderCount
End Sub

 

[SkyWalker1012]

OOps ... I see the issue is that I didn't have a spaces around the &. It's working now