ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   text wrapping in excel (https://www.excelbanter.com/excel-programming/273514-text-wrapping-excel.html)

gil eiliya

text wrapping in excel
 
hi.

i'm building a program in vb6 on win98, i am using excel to build a
shipping bill, using data i get from my data base, my biggest problem
is that i have a long text field in the DB that i need to insert in
the excel worksheet, i know how to select few adjusting cells, merge
them to one cell, (using a macro), i insert the long text to the cell,
i use a text wrapping macro i builded, but then the cell continues to
span only one row height even if there are 2 or more lines of text
wrapped, here is my problem how do i find how many wrapped lines is
there so i can resize the row to the right height according to the
number of lines?, i know that in excel if you press alt + enter keys
when you write a long text you break the text into new lines, but how
do i find how many rows?

thanks in advance for any help.
gil eiliya.

Ed Ferrero[_4_]

text wrapping in excel
 
Hi gil,

With Worksheets(1).Range("myRange")
.WrapText = True
.Rows.AutoFit
End With

--
Ed Ferrero
http://edferrero.m6.net




All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com