I created an excel application where the users enter the comments for every question.
I have designed the excel spreadsheet in such a way that, I have merged cells to capture large text data. The problem I have been coming across is when the comments exceeds more than three lines and when I need to print the excel file, it crops the cell content.
How do I dynamically increase the cell size when the text entered is big enough. ?
Private Sub Workbook_Open()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
ThisWorkbook.Sheets("Sheet1").Activate
Application.PrintCommunication = False
With Sheets("Sheet1").PageSetup
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = False
End With
Application.PrintCommunication = True
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub