M
Mark G
I have a workbook in which, depending on selections made on one worksheet, the information displayed on another varies. The text is pulled in from a hidden worksheet. Since the required row height can vary I want to use Row Autofit to automatically adjust this. However, for some reason a few of the rows do not adjust - cutting off several lines of text. I can manually adjust this but would bascially have to set each row for the maximum possible height to accomodate all possibilities.
I am aware that if you manually adjust the row height and then turn on Wrap Text, the Autofit function may not work properly. I have gone back, selected all rows, turned off Wrap Text, used Row Autofit and then turned Wrap Text back on. This has worked for most of the rows but for some reason not all of them. I have reivewed much of the comments posted previously but these do more with merged cells, which I do not have.
Any ideas why or hw I can get around this?
Thanks,
Mark
I am aware that if you manually adjust the row height and then turn on Wrap Text, the Autofit function may not work properly. I have gone back, selected all rows, turned off Wrap Text, used Row Autofit and then turned Wrap Text back on. This has worked for most of the rows but for some reason not all of them. I have reivewed much of the comments posted previously but these do more with merged cells, which I do not have.
Any ideas why or hw I can get around this?
Thanks,
Mark