N/APosted on - 09/17/2011
Been trying to script Excel with a code that is not completely correct but I am looking for a way that I can get the script to ignore all the errors. Here is the error message;
The command could not be completed by using the range specified. Select a single cell within the range and try the command again.
Microsoft Excel The command could not be completed
Excel is no doubt a versatile spreadsheet software which provides unlimited flexible formatting options available for application. All such options and formulas have their unique syntax without which our command remains useless and unfruitful.
The error you mentioned generally occurred while applying formulas or mathematical calculations to a cell like in such cases if we select wrong range of cells or if we select various cells instead of a single cell. The error message is to a greater extent self explanatory which is saying that you should select only a single cell to complete your required command.
Hope it clarifies.