Invalid use of property while delete cells

Question

What am I doing wrong ?

MAJPRIXFORMAT.Cells(x, "C").Delete shift: xlToLeft

return me : "Invalid use of property" and highlight xlToLeft

MAJPRIXFORMAT is a var worksheet

This line should delete a cells and moove other cells to the left..

Answer 1

You are missing the = sign:

MAJPRIXFORMAT.Cells(x, "C").Delete shift:=xlToLeft