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