Hey DK,

When I run the queries to populate my spreadsheet there
are about 74 cells that are being named. Everday I run
these queries the cells are being renamed with another
dynamic name the query is applying. I will run these
queries every business day so eventually I will have 250+
days creating 74 names a day. I am affraid that
eventually the routine could create so many named cells
that the sheet will blow up. Will it hurt to have a
constantly growing list of defined names?

-----Original Message-----
Ray

I don't think it's possible. Why do you want to do it?
Maybe there's
another solution to your problem.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

Ray wrote:
hey, i am running a query from excel 2002. when the
query populates the cell the query is naming the cell.
I
would like it to stop doing that... any ideas? Thanks
for
any help you can give.


.