Standard charachter count?
Is there a standard amount of charachters per line in excel?
Right now I have an If statement that tests the rowheight, but I have found that there is a problem with this.
The macro puts each name in the same cell but skips ahead 10 charachters to go to the next line.
What I would like to do is make the if statement based on the number of charachters in the cell, and not it's height.
so right now it says:
if the row height is X, then offset(0,1)
I want it to say
if the charachters in the cell are X(the X here is the big question), then offset(0,1).
Re: Standard charachter count?
Quote:
but skips ahead 10 charachters to go to the next line.
Are you sure that your source data doesn't have trailing spaces?
Quote:
if the charachters in the cell are X(the X here is the big question)
You could check the LEN of the text in teh cell.