Inserting variable number of cells (not entire rows)

[Yamezz]

I can find plenty of threads about inserting rows in this manner, but not individua cells.
What is the correct syntax to insert CellsToInsert number of cells into columns I and J?

For a single insert I currently have the code

Range("I" & ErrCell.Row, "J" & ErrCell.Row).Insert xlShiftDown

 

[Akuini]

What is the correct syntax to insert CellsToInsert number of cells into columns I and J?

Maybe:

Range("I" & ErrCell.Row, "J" & ErrCell.Row).Resize(CellsToInsert).Insert xlShiftDown

 

[Yamezz]

Thank you. That works.

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.