Excel 2007, determine count of rows in a spreadsheet

<< Excel 2007, determine count of worksheets in a spreadsheet | Home | What to do with User Account Control in Vista >>

Excel 2007, determine count of rows in a spreadsheet

I had to determine how many rows are in a speadsheet with VBA.

Dim rowCount as Integer
rowCount = ActiveSheet.UsedRange.Rows.Count

posted @ Monday, December 07, 2009 8:01 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 7 and 7 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: