"Chrissy" wrote in message
...

The named range called SheetName (I think that is what I called it) is the
reference to row 1. To confirm this go to menu Insert -- Name -- Define

Hi Crissy,

I played with you demo and tried to change some parameters to get familiar
with this. It worked fine in your test app, but when I apply it in our
'real-world' workbook I get #value errors.

Instead of naming a complete column as you did, I name a cell range, and
instead of naming a complete row as you did, I name a set of cells in the
same row. Would that be a difference?

This workbook is small, would it be possible that you could have a look at
it to point out what's the problem...?

Thanks anyway

greetings

Tor