Thread: where text wraps in a cell, how can the row height be auto set?
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
The Code Cage Team[_44_] The Code Cage Team[_44_] is offline
external usenet poster
  
Posts: 1
Default where text wraps in a cell, how can the row height be auto set

I'm not sure whats happened there but drop this in to the worksheet code
module:

Code:
--------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Rows.EntireRow.AutoFit
End Sub
--------------------
every row you click should autofit!


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=37732

Reply With QuoteReply With Quote