ineffieient...no. I use range names several different ways.
as table names with linking access to excel files
as set print in a macro that prints out a reports
and others ways that i can't seem to think of right now.
memory hogs. not sure. don't think so. but i would use
them anyway even if they were.
-----Original Message-----
Hi,

I have a workbook with a ton of Named Ranges (done by
Insert/Name). Are
these inefficient and memory hogs? I have procedures
that reference these
dynamic named ranges, so I kind of need them. Just
curious if having 200 or
so of them is slowing things down. Thanks!



.