Forum Discussion
Solved
Excel script run with error since today (Range Delete)
I have a script that manipulates an excel table by deleting columns and adding new ones. The script that yesterday worked correctly today stops working and i get these errors: Range delete: You cann...
I guess that's this sample ExcelScript.DeleteShiftDirection enum - Office Scripts | Microsoft Learn
"delete" doesn't work in Excel Desktop. If you run exactly the same script in Excel for web it shall work.
StefanMogyorosiSame problem here... even on a completely blank worksheet, even using the [script recorder] to ensure it doesn't contain any typing errors, the insert and delete methods throws this error. Another interesting fact is that the same operation using the old VBA works.
The same script worked flawlesly weeks ago. Today, this insert operation is not working at all in Excel Script, just in VBA.