Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data types

Hi,   I have a query that does the job. Problem is when i try to run VBA on it, i have a set of columns with one of them being formatted as text. I run a VBA module on it, that defines the range as...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

I'm not expert of VBA, as searched, there are some casues and solutions to this error:

https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/type-mismatch-error-13

 

if you want to count the rows in Power Query, you could easily achieve as below:

Or filter out null for a column and count based on the column

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.