Len(str)

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

When I use this function and I have, for example, cnt = 1,
the len for some reason is equal to 2. Why is that? Am I
doing something wrong?

Thanks

Daniel
 
I am making Unique ID's with numbers and characters. I
need to know the length of the number to know if and how
many 0's to put before the 1,2 etc, so that it will be
ordered in the correct manner. Otherwise when I hit 10, it
is indexed back to the beginning.

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make VBA ComboBox_Change work in 3 sheets 1
Update query using Count 4
Help with code 5
Plurals 5
Choosing a camera lens for low-light photography 14
For Sale Praktica L Analog camera outfit for sale 0
Error Adding to Spreadsheet Please help!!! Complex ? 1
wrong number of arguments for function 1

Back
Top