How to count number of filled cells in specific row?

Help
1

How to I count the number of filled cells in a specific row? can be 01 or 02 or 22 - this depends on the variable.
Thanks!

image
image1303×236 9.65 KB

2

@SJL

You can do using datatable, using read range you can get the datatable

and also using filter datatable you can put a condition that column = null

then you can check the count

Hope this helps

Thanks

3

if row(0).ToString.Equals(“”)
in else part
nonEmptyRows = row(0).ToString
and print nonEmptyRows