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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting the row height in Excel with VB

Status
Not open for further replies.

Evening

Technical User
Jan 19, 2005
45
0
0
CA
I have a spreadsheet with some 1000 rows and 20 columns. The fields are formated with a wraped text feature. Some of the fields contain longer text, so even they are formatted with wrapped txt, can't be readable when I print the sheet out, because the row height is not enough . I don't want to set all rows very high .
I doing some calculations in VB in ths sheet anyway, i was thinking is it possible to run some code which will adjust each row height so, that the txt can be readible fully when i print out the document.
 
Thanks Loomach for help, it looks it's working
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top