On your sample it worked fine.
Please make sure of the following :

- Put the code in the WORKSHEET CODE AREA of worksheet with the name 'Full Report'
- Run the code while the 'Full Report' sheet is the active sheet

Please try again - make sure you don't put the code in a module, but in the worksheet code area of "Full Report"
Thanks