Excel 2007, determine count of worksheets in a spreadsheet

<< Record count of all tables in a database | Home | Excel 2007, determine count of rows in a spreadsheet >>

Excel 2007, determine count of worksheets in a spreadsheet

If you need to know how many worksheets in a spreadsheet.

Dim sheetCounter as Integer
sheetCounter = ThisWorkbook.Worksheets.Count

posted @ Monday, December 07, 2009 8:00 AM

Print

Comments on this entry:

No comments posted yet.

Your comment:

Title:

Name:

Email:

(will not be displayed)

Website:

Comment:

Remember Me?

Please add 3 and 6 and type the answer here:

Enter the code shown above:

Live Comment Preview:

February

Sun

Mon

Tue

Wed

Thu

Fri

Sat

29

30

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

1

2

3

4

5

6

7

8

9

10

About

Tag Cloud

Archives

December, 2009 (62)

Post Categories

Links

Blog Catalog

Syndication: