A part of the macro I wrote adds a new sheet to the active workbook. Until now, the code was working fine, but today I encountered the error message "That Command cannot be used on multiple selections", while trying to run the simple code:
I have realized that this error happens only when the other part of the macro runs the following code:
I cannot understand why this error happens, because before even when the code SaveCopyAs was ran I did not have any problem with adding sheets, and since then I have not changed anything about this part of the code where it adds new sheets.
Somewhere on the web somebody suggests using the following code:
Note that I am using Excel 2010.
P.S: After running the SaveCopyAs code mentioned above, I also cannot add sheets manually via Excel.
By the way, I have no idea why, but my thread keeps on vanishing without any notice, and therefore I have to keep on reposting it