reginaldojunior / winners

		if ($pSheet !== NULL) {

//			echo 'Passed sheet name is '.$pSheet->getTitle().'<br />';

//			echo 'Range reference is '.$pRange.'<br />';

			if (strpos ($pRange, '!') !== false) {

//				echo '$pRange reference includes sheet reference<br />';

				$worksheetReference = PHPExcel_Worksheet::extractSheetTitle($pRange, true);

				$pSheet = $pSheet->getParent()->getSheetByName($worksheetReference[0]);

//				echo 'New sheet name is '.$pSheet->getTitle().'<br />';

				$pRange = $worksheetReference[1];

//				echo 'Adjusted Range reference is '.$pRange.'<br />';

			}

			// Extract range

			$aReferences = PHPExcel_Cell::extractAllCellReferencesInRange($pRange);

		if ($pSheet !== NULL) {

//			echo 'Current sheet name is '.$pSheet->getTitle().'<br />';

//			echo 'Range reference is '.$pRange.'<br />';

			if (strpos ($pRange, '!') !== false) {

//				echo '$pRange reference includes sheet reference<br />';

				$worksheetReference = PHPExcel_Worksheet::extractSheetTitle($pRange, true);

				$pSheet = $pSheet->getParent()->getSheetByName($worksheetReference[0]);

//				echo 'New sheet name is '.$pSheet->getTitle().'<br />';

				$pRange = $worksheetReference[1];

//				echo 'Adjusted Range reference is '.$pRange.'<br />';

			}

			// Named range?

			$namedRange = PHPExcel_NamedRange::resolveRange($pRange, $pSheet);