What are you trying to count. Names that include a sheet name in the name

Sheet1!List

as an example, or names that refer to a specific sheet regardless of whether
they are sheet level or workbook level.

--
Regards,
Tom Ogilvy


"nozben" wrote:


hi,
this code "activeworkbook.names.count" help me to detemine the number
of activeworkbooks which are defined by using insert/name/define the
range. But I have a problem with this code. Because this code determine
all workbook in excel file. Instead of this, I wanna just determine them
in one certain sheet. Such as sheet1. I Dont know how I can overcome
this roblem.


--
nozben
------------------------------------------------------------------------
nozben's Profile: http://www.excelforum.com/member.php...o&userid=35566
View this thread: http://www.excelforum.com/showthread...hreadid=553282