COUNTA function in VB

  • Thread starter Thread starter Phillip Topping
  • Start date Start date
P

Phillip Topping

I can use the COUNTA function successfully within my worksheet to get the
desired answer but I am having trouble using it in VB even though the help
file says it can be used in macros.

Any help would be greatly appreciated.

TIA
Phillip
 
This is from an armature but I was having trouble using VLookup in
macros and learned here that the syntax is:
Application.WorksheetFunction.VLookup(...... Suspect that is the
solution to your problem.

Ed
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with COUNTA formula 2
CountA question 2
COUNTA or COUNTIF?? 7
Using the COUNTA function 1
Referring to a portion of a column 1
COUNTA Confusion.... 8
EXcel 2000 IF-AND Statement 3
Excel Excel 2007 - Workbook CountA and sums help needed 8

Back
Top