COUNTA function in VB

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
 
E

Ed Bitzer

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
 
Top