Cannot delete spreadsheet cells ERROR

N

Nikki

Has anyone ever gotten this message? I was trying to run a Macro to
automatically update a spreadsheet within Excel and got the "Cannot delete
spreadsheet cells" error. I had to go into the spreadsheet and delete the
contents that was previously exported. Does anyone know why the data could
not be overwritten without having to go into the spreadsheet and delete the
information first before importing? Also, is there a setting that I could use
in the Macro to delete the information automatically upon the export? Any
help you have is greatly appreciated.

Thanks for your help.

Nikki
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
MS Project Import Error Row 1 Column 5 2
Missing default cell styles on some large existing spreadsheets 0
Cannot expand named range. 1
"cannot shift objects off sheet" error 8
Import/Export Question 0
Importing spreadsheet cells that have multiple values 1
Varying cell ranges in formulas according to number of cells with certain value 1

Top