As in my previous post that still works perfectly for me independant of
whether the ranges are referenced absolutely.

Mike

"Werner Rohrmoser" wrote:

Hi Bernd,

is your name really defined as: =Sheet1!C1 or as Sheet1!$C$1?
When you use mixed relative or relative names it doesn't work and
this is my problem.

Regards,
Werner