GS explained :
To give a named range local scope:
Select the range
In the namebox to left of the Formula Bar, type:

'<sheet name'!DataSource

..where <sheet name should be replaced with the actual worksheet name

Be sure to press 'Enter' after typing in the namebox!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc