Microsoft Excel The command could not be completed

Hi guys,
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;
Microsoft Excel
The command could not be completed by using the range specified. Select a single cell within the range and try the command again.
Much thanks.
