VBA How to fetch raw numbers within a table column

[Klash Ville]

Hello everyone, I have the following situation creating me an obstacle:

I have a table column which contains words and numbers. From that same table column, is it posible to create a VBA command Selecting only the numbers within that column while ignoring everything else such as words in this case?

The final result would be a SUM of all these numbers that have been Selected.

 

[MickG]

Try this, for column "A":-

MsgBox Application.Sum(Range("A:A").SpecialCells(xlCellTypeConstants, xlNumbers))

 

[Klash Ville]

Try this, for column "A":-

MsgBox Application.Sum(Range("A:A").SpecialCells(xlCellTypeConstants, xlNumbers))

Thank you for your answer, although, it's giving me an overflow error and I know why.

Could you provide me a fix on that code for only the visible cells within that column range please?

 

[Klash Ville]

nvm it's working now.

    Dim x As Integer
    
    x = Application.Sum(Range("E:E").SpecialCells(xlCellTypeVisible, xlNumbers))
        
    MsgBox x

Thank you so much my friend =)

 

[MickG]

You're welcome