activeworkbook counting

  • Thread starter Thread starter nozben
  • Start date Start date
N

nozben

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to force macros refer to ActiveWorkbook 2
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Hide Defined Names 3
Copy two sheets from workbook & create new workbook 8
Excel 2007 - Dynamic sheet naming 1
Adding a sheet to a workbook 1
Worksheet copy problem 2
Selectively Delete Defined Names 2

Back
Top