Hi to all,

I dont know why following line of code in my macro is giving a compile
error

Single line Code

currency_check = Application.WorksheetFunction.COUNTIF(N:N,"<GBP") -
Application.WorksheetFunction.COUNTIF(N:N,"<"&"*" )

<<<Single line Code

I have declared it as
Dim currency_check As Integer

But the compiler objects at ":" (n:n) part of function and says that,"
Expected List Seperator or )"

Kindly advice.

With Regards,

Ashish