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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by lasseX
-
Autofit text in merged cells
Do you know how to do this also :) Private Sub Worksheet_Change(ByVal Target As Range) If (Target.Address = "$F$9") Then End if End function I have named the cell $F$9 to Test, how do I use this name instead ?- lasseX
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
-
Autofit text in merged cells
Thanks!! I will lock into that! Do you know if it is possible to run c.EntireRow.AutoFit but not change anything in excel sheet ? To get the height without change anything. Set c = Range("A1") c.EntireRow.AutoFit NewRwHt = c.RowHeight- lasseX
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Autofit text in merged cells
Hi Skip, Thanks for the answer. I can not do it manually, I need to do it in automatic in some way.... and I need to have merged cells ... :( Thanks- lasseX
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Autofit text in merged cells
Hello, I have searched the internet after som code that deals with wrap text on merged cells. I have found some but nobody seams to work for me :(. The backgroud: I have one row of cells: Group1: A1:C1 are merged Group2: F1:G1 are merged Group3: I1:K1 are merged I would like to...- lasseX
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
