View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Gerstman David Gerstman is offline
external usenet poster
 
Posts: 57
Default Referencing a value on a different worksheet

Elkar,

Thank you for the response, but that did not do the trick.

I still get the formula displayed and not the value.

David

"Elkar" wrote:

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