How to delete all rows of a table skipping the first row with Excel Script without fail by this error, Table deleteRowsAt: The argument is invalid or missing or has an incorrect format.

Question

Hello evreyone,

Could someone help me with this?

I'm trying to delete all rows of a table skipping the first row, because this table have formulas, and I don't want to delete the first row to keep the formulas.

When I run the script, it does what I want but no matter how I change the script it allways get the error:

Table deleteRowsAt: The argument is invalid or missing or has an incorrect format.

The issue, is that I need to use this script with power automate and it's known that a script with errors cause the flow breaks.

Answer 1

Try this: table2.deleteRowsAt( 1, rowCount2 - 1 ).