When referencing a merged cell, only reference the top-left most cell in the
merged area. So, in your case:

='07PAGE-1'!B7

HTH,
Elkar


"David Gerstman" wrote:

I have a form in Excel.
The second (work)sheet of this form references a field from the first
(work)sheet. (Specifically the name.)
So I enter the "=" and then I click on the first (work)sheet and click on
the cell I want to reference and click "enter" and this is what I get on the
second sheet.
='07PAGE-1'!B7:I7

It doesn't resolve itself into the name.

Why not?
Clicking on the accompanying error message it seems possible that it doesn't
work because the cells (both the source and the destination) have been merged.

Is that what's wrong? If so is there a workaround?

Is there a different mistake?

Thanks.