Simple error in Application.Count

[Klash Ville]

Hello everyone, I have this piece of code:

    Dim counting_2 As Integer
    Dim counting_3 As Integer
    Dim counting_4 As Integer
    
    counting_2 = Application.Count(Range("Tabelle2[Chemical System_2]").SpecialCells(xlCellTypeVisible))
    counting_3 = Application.Count(Range("Tabelle2[Chemical System_3]").SpecialCells(xlCellTypeVisible))
    counting_4 = Application.Count(Range("Tabelle2[Chemical System_4]").SpecialCells(xlCellTypeVisible))


    MsgBox counting_2
    MsgBox counting_3
    MsgBox counting_4

The target table ranges have exacly 15 rows of content, yet, the variables always return me 0...

What's the problem?

 

[Marcelo Branco]

Try
Application.CountA(...)

M.

 

[FormR]

The target table ranges have exacly 15 rows of content

Hi, what type of content? Count() will only count numbers.

 

[Klash Ville]

Try
Application.CountA(...)

M.

Thanks, I was missing the A...

 

[Klash Ville]

Hi, what type of content? Count() will only count numbers.

Yap, I was missing the A... the content was only strings =/