I am trying to insert a new row into an Excel sheet. I open a file with Powershell, get an object for the sheet, and then get a range object like

$Range=$Sheet.Range("A1")
$Range.Insert()

As I am typing insert, Powershell will even do the tab completion. So, it sees the method there. But when I run that line, I get the error

OperationStopped: Unable to get the Insert property of the Range class

Does anyone know what is going on here, or another way to insert a row? I can’t go to the end of text within the worksheet because my data is in a table and there is another table under that. So, it’s not that straight-forward.