I can't repro this problem. I tried Excel 97 through 2003 since you didn't
mention your version.

--
Jim
"Mariano" wrote in message
...
| Often on one of my workbooks I need to reference a cell from either
another
| workbook or worksheet. I usually have both workbooks open so I just hit
the
| equal sign and click on the cell i want referenced. However when I do
that
| when I am trying to reference a merged cell it automaticall pulls up a
range
| of both of the merged cells and retuns a #value.
| Is there anyway to click on it and actually have it pull up a single cell
| instead of creating something like?:
| Sheet2!A1:B1