I’m trying to find a way to get the elements of the cell as a string and then use this length as a integer if I write something like len(range(cell(i,j)) then it gets stuck in a error of syntax. I tried to find something here in stack. I know that I would need to convert this range to a string, but I don’t know how to do it.
Sorry, I’m new to VB
>Solution :
Use Len(Cells(i,j)) but Cells(i,j).Characters.Count will also work.
BigBen pointed out in the comments that Range().Characters.Count throws a error when working with numeric data.