Hello!
So this is a new thing that has cropped up. I have a macro that is supposed to delete columns and rows but it throws the Error "Delete method of Range class failed". I investigated and the macro is the same that I had used with the previous version of Excel, but the document will not allow me to delete columns or rows at all, even manually. I have it unprotected and I can select the columns or rows and right click to delete and it clears the cells of all text but leaves the columns there only blank instead of deleted.
Example Not Deleting.jpg
We did just update from Office 2013 to Office 365 and the macro worked before we updated.
Any help would be appreciated.
Bookmarks