get total row's value through VBA

[bart tuytten]

Hello,

I am trying to get the value of a total row's cell into a variable.
As I hover over the code in the IDE, it shows that the value is equal to 4.
Yet i am not able to introduce that number in the count variable I defined before.

Do you have a suggestion on how to solve this matter?

 Dim count As Double
    count = Database.Range("Tabel_mat[[#Totalen],[Selectie]]").Value
    MsgBox (count)

regards, Bart

 

[BSALV]

count is a term used within VBA and i fear the compiler doesn't know what to do with it.
Try to avoid that kind of names, try for example MyCount or iCount and stay away of those VBA terms for variables

 

[bart tuytten]

count is a term used within VBA and i fear the compiler doesn't know what to do with it.
Try to avoid that kind of names, try for example MyCount or iCount and stay away of those VBA terms for variables

Hello,
your remark concerning the term is correct indeed.
Yet, when changing the variable's name, the issue remains.
Thank you for your reply.

 

[bart tuytten]

count is a term used within VBA and i fear the compiler doesn't know what to do with it.
Try to avoid that kind of names, try for example MyCount or iCount and stay away of those VBA terms for variables

Hi again, in the meantime it occurred to me that I am using a Dutch Excel version. I forgot about the '#Totalen' needs to be '#Totals'.
An issue i encountered before but i had forgotten, yet i was confused because of the hovering tool indicating a valid result.
I can continue now, yet I thank you for your effort to consider my post.
Regards, Bart

 

[BSALV]

my native language is also dutch, so i didn't see it