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 derfloh 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
Joined
May 18, 2002
Messages
119
Location
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