OtterlyAdorable
New Member
- Joined
- Apr 10, 2013
- Messages
- 5
I'm not great with VBA, but I think it's the only way to solve this puzzle.
I have a table with one picture in a particular cell that will move around. (It's a linked picture to a table, since you can't nest tables. -___- )
What I would like is this: A macro/VBA code that will BOTH expand a row's height if the wrapped text drops to the next line/s, and will also keep the row height of the picture the same upon table sorts.
I found some code for the row height bit:
But this doesn't help me with the picture. It resets the picture row height to 1 line high each time I sort.
I hope I made this clear enough. Thanks for any help!
I have a table with one picture in a particular cell that will move around. (It's a linked picture to a table, since you can't nest tables. -___- )
What I would like is this: A macro/VBA code that will BOTH expand a row's height if the wrapped text drops to the next line/s, and will also keep the row height of the picture the same upon table sorts.
I found some code for the row height bit:
Code:
[/COLOR]Private Sub Worksheet_Change(ByVal Target As Range)If Target.Count <> 1 Then Exit Sub
Target.Columns.AutoFit
End Sub
[COLOR=#333333]But this doesn't help me with the picture. It resets the picture row height to 1 line high each time I sort.
I hope I made this clear enough. Thanks for any help!
