count the entries in a row in vba

Question

0.00/5 (No votes)

See more:

It's a simple question with an easy solution I think :D

But it looks like i'm to stupid to get it:

I have a row in Excel with some entries

  A      B      C       D       ...
3 entry1 entry2 entry3  entry4  ...
4 entry4 entry5 entry6  entry7  ...
5 entry8 entry9 entry10 entry11 ...
.                         .
.                         .
.                         .

Well I need to count all entrys in line 3 and the result.
After I do the same with line 4 and so on

Posted 15-Jul-15 2:22am

Chi Ller

Updated 15-Jul-15 2:53am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2015-07-15T02:42:00

Solution 2

Do yu mean you would like to show the amount of filled cells within the row?

If that is the case, try something like

VB

rownum = Range("A3").Row
test = Application.Evaluate("COUNTA(" & rownum & ":" & rownum & ")")
MsgBox test

Posted 15-Jul-15 2:42am

Wendelius

Comments

Chi Ller 15-Jul-15 8:54am

sorry the first version of the question was not clearly :D I hope it's better now
But it works :D
Thanks a lot

Wendelius 15-Jul-15 9:12am

You're welcome :)