Error when writing XLSM!

Topics: Developer Forum
May 15, 2014 at 5:45 PM
I have copied the code from a previous post that copies an excel spreadsheet with macros into another sheet but the spread sheet I am using keeps throwing the error:

Fatal error: Uncaught exception 'PHPExcel_Exception' with message 'Invalid cell coordinate 'SHR - MURDER' in C:\wamp\www\Excel_Old\Classes\PHPExcel\Cell.php on line 539

I understand what this line means but I can't understand why it is using a worksheet name as a cell reference.

Can anyone help me find out where this can be fixed from or why it is doing what it is doing?