Data types

[Anonymous]

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 long. However, one text column refuses to work on it and returns error 13 (type mismatch). 

The script is basicly .Cells(.Rows.Count,"A").End(xlUp).row, so im counting rows. Why is the text data type not working?

[v-juanli-msft]

Hi

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft]

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-err...

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.