Hey,
I am new to Excel VBA and was wondering if anyone had any other solutions to using dot leader with wrapped text ? Listed below are the methods I have explored and other questions I have.
Explored
1. Count the number of spaces left in a cell based on width and then add that many "." to the string.
2. Inserting a column in-between filled with "." and adjust alignment.
Other Questions
1. Can you stop text wrapping after a certain number of characters ?
2. Can you add a new line + autofit a row without turning on wrapping ?