Tags: counta, desired, excel, function, microsoft, msdn, software, successfully, trouble, worksheet

COUNTA function in VB

On Microsoft » Microsoft Excel

899 words with 1 Comments; publish: Thu, 22 May 2008 23:55:00 GMT; (30660.55, « »)

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

All Comments

Leave a comment...

  • 1 Comments
    • 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

      "Phillip Topping" <ptopping.excel.todaysummary.com.tpg.com.au> wrote in message

      news:u6Nf1WfYDHA.1004.excel.todaysummary.com.TK2MSFTNGP12.phx.gbl...

      > 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

      >

      #1; Thu, 22 May 2008 23:57:00 GMT