A couple of ways
1. Select a rangeinsertnamedefinename it
1.a define it in the formula is box
2. select a rangetype in a name in the NAME box next to the formula box

--
Don Guillett
SalesAid Software

"keri" wrote in message
ps.com...
My other half is data engineer for the NZ team! I had a wicked weekend
celebrating for them!

Thanks for the integer answer.

Anyway, no I realised my mistake with the sheet names and changed them.

What is an Excel Defined Name?

(In case you're wondering i've learnt basic VBA in Access but never
used Excel before....it's certainly interesting trying to make Access
knowledge work on this).