Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel CVA - control wordwrap in print statement

Status
Not open for further replies.

csbdeady

Programmer
May 18, 2002
119
GB
Hi

Is it possible to control the wordwrap to limit a line to 80 characters when using the Print # statement in VBA 6?

Although I could just count the number of characters in a string, the wrapping would be all over the place as:
- each string may already include carriage returns (the data is being retrieved from Excel cells each containing multiple lines of text)
- if I wrapped at character 80 it would split words up in the middle.

Any thoughts?

Many tas as usual!
-Colin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top