count no.of values in a
column
Dear Noorain,
good method..
--
Sent from my Nokia phone
--Original message--
From: NOORAIN ANSARI
To:
Date: Thursday, March 15, 2012 6:48:28 PM GMT+0530
Subject: Re: $$Excel-Macros$$ Need Vba code to count no.of values in a
column
Dear Naresh
Dear Noorain,
good method..
--
Sent from my Nokia phone
--Original message--
From: NOORAIN ANSARI
To:
Date: Thursday, March 15, 2012 6:48:28 PM GMT+0530
Subject: Re: $$Excel-Macros$$ Need Vba code to count no.of values in a column
Dear Naresh,
You can also try without using
Dear Naresh,
You can also try without using worksheet-function.
Sub Count_value()
Dim i, rw As Integer
rw = Range("A65536").End(xlUp).Row
counter = 0
For i = 1 To rw
If Range("A" & i).Value <> "" Then
counter = counter + 1
End If
Next i
MsgBox counter
End Sub
--
Thanks & regards
Hi,
try
sub count_a()
dim x as long
x=appplication.worksheetfunction.counta(a:a)
msg box x
end sub
--
Sent from my Nokia phone
--Original message--
From: Naresh V
To:
Date: Thursday, March 15, 2012 4:25:11 PM GMT+0530
Subject: $$Excel-Macros$$ Need Vba code to count no.of
Why not you use excel-count function. It will be easier than code.
Anyway the same thing is used in code. check out.
Sub counts()
MsgBox Application.WorksheetFunction.Count(Range("A:A"))
End Sub
Regards
Kumar
On Thu, Mar 15, 2012 at 4:25 PM, Naresh V wrote:
> Group,
>
> Can you please pr
Group,
Can you please provide the vba code for count no.of values in a column.
Ex:
*A clumn B column*
1
23
44
55
12
71
I want code to count A column
Regards,
Naresh V
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like P
