Help with For function and FormulaR1C1

[CoolMacro]

Now I have a sheets with a first date and a last date of a period.
In other sheet I need complete a series of dates by columns with their respective workdays on this period.

I'm trying with For function and then using the formula "=Workday(RC[-1], 1)" like this:

Sub Período()


    Application.ScreenUpdating = False
    
    Dim j As Long
    
    With Sheets("Período")
        .Select
        
        For j = 1 To Sheets("Início2").Range("C1").Value Step 1
            .Cells("B", j).FormulaR1C1 = "=workday(RC[-1], 1)"
        Next j
    End With
        
        Application.ScreenUpdating = True
        
End Sub

But appears a Error, whats I'm making wrong?

 

[Comfy]

You are using the Cells property incorrectly.

The row should be specified first followed by the column.

E.g. .Cells(j, "B").FormulaR1C1 = "=workday(RC[-1], 1)"

 

[CoolMacro]

Thanks. I saw my mistake.