Use Offset with Columns()

[288enzo]

Is it possible to use Offset with Columns()? I'm getting an error, so either the answer is no, or there is something I'm missing. I've been searching and searching, I haven't found anything that says I can't, but on the other hand, I haven't found anything that says I can.

Application-defined or object-defined error​

    With Sheets("employees")
        With .Cells.Font
            .Size = 9
        End With
        With .Columns(14)
            .EntireColumn.Insert
            .Offset(-1).ColumnWidth = 10.71
        End With
End With

Without the offset, Columns(15) is formatted to 10.71.

 

[Z51]

When using Offset, the parameters are Offset(rows, columns), so perhaps try ".Offset(0, -1).ColumnWidth = 10.71"

 

[288enzo]

When using Offset, the parameters are Offset(rows, columns), so perhaps try ".Offset(0, -1).ColumnWidth = 10.71"

Thanks, silly mistake. Much appreciated. Missing a comma

    With Sheets("employees")
        With .Cells.Font
            .Size = 9
        End With
        With .Columns(14)
            .EntireColumn.Insert
            .Offset(,-1).ColumnWidth = 10.71
        End With
End With