VBA Count Function

[Todd Huttenstine]

hey guys

I have a range of data in column P. I know the Excel
count function but in this case, I need to use the count
function in VBA. I looked in help and could not find it.
Because the range of data can vary in the column, the data
will change. How do I use VBA code to count the number of
values in the columnP? After I do this I can store it as
a variable and use it in my code.


Thank you

Todd Huttenstine

 

[Chip Pearson]

Todd,

You can call worksheet function in VBA with the
Application.WorksheetFunction class. E.g.,

Dim Res As Long
Res = Application.WorksheetFunction.Count(Range("P1100"))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Todd Huttenstine]

Thank you.

-----Original Message-----
Todd,

You can call worksheet function in VBA with the
Application.WorksheetFunction class. E.g.,

Dim Res As Long
Res = Application.WorksheetFunction.Count(Range ("P1100"))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message news:[email protected]...


.