AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 1,940
- Office Version
- 2019
- 2016
- Platform
- Windows
My maths is lousy and I can't quite work this out!
If each line in a comment starts at position
51
98
145
213
How can I calculate each lines length ?
I got the start position with
If each line in a comment starts at position
51
98
145
213
How can I calculate each lines length ?
I got the start position with
Code:
For f = 1 To Len(comment.text)
If Mid(comment.text, f, 1) = vbLf Then Debug.Print f + 1
Next