Used cells count

[excel09]

How would you be able to count all the used cells in a specific column?

I know the following would count all used cells in a worksheet but what about a specific column?

Please Login or Register  to view this content.

[Richard Schollar]

Hi

Intersect the UsedRange agaiunst the column you want to count:

Please Login or Register  to view this content.

Richard

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[excel09]

Thanks.

It counted all the cells in the column though. I am just trying to count cells that have data in them. Cells are either blank or are marked with an 'x' so i am just trying to count the cells with 'x' in them.

How would i go about doing that?

[excel09]

I tried the following but still doesnt work:

Dim num As Integer

num = Application.CountIf(Sheets(1).Range("B"), "x")

MsgBox num

It throws up an application or object defined error

[royUK]

Use Counta

Please Login or Register  to view this content.

[excel09]

Thanks. It works

[royUK]

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save