hi
the best idea i can give you is not to use merged cells.

Regards
FSt1

"OrlaLynch" wrote:

From reading the comments here, it looks like the general idea is not to link
merged cells but is there any workaround to linking merged cells to merged
cells? I've tried to reference the whole range and the top left cell, e.g
=Sheet1!A9 but neither work for me.

Please give me ideas!It seems so simple but I can't get them linking!
Thanks,
Orla