S
Stewart Allen
I'm trying to automatically resize the row height after merging cells in a
row and wrapping the text. Is there a way to do this.
My code so far is:
ActiveSheet.Range(.Cells(3, 2), .Cells(3, 5)).MergeCells = True
ActiveSheet.Cells(3, 2).WrapText = True
The data being inserted into this range is being pulled from an Access text
field so I need the row height to automatically adjust depending on how much
data is extracted. If I don't merge the cells the row will automatically
adjust its height but won't if they are merged.
Stewart
row and wrapping the text. Is there a way to do this.
My code so far is:
ActiveSheet.Range(.Cells(3, 2), .Cells(3, 5)).MergeCells = True
ActiveSheet.Cells(3, 2).WrapText = True
The data being inserted into this range is being pulled from an Access text
field so I need the row height to automatically adjust depending on how much
data is extracted. If I don't merge the cells the row will automatically
adjust its height but won't if they are merged.
Stewart