T
Tom George
Hi,
I am trying this in my code and there seems to be a limitation on how the
rowheight of 255 pixels. Is there any way around this? I am trying to get
the rowheight to autofit and i have some large text fields that I am pulling
into the spreadsheet. IT will not set the rowheight larger than the 255
pixels and as a result there is text that is not visible on the sheet.
TIA,
Tom
Range("a2").Offset(GlobalCounter, j + 1).Rows.AutoFit
I am trying this in my code and there seems to be a limitation on how the
rowheight of 255 pixels. Is there any way around this? I am trying to get
the rowheight to autofit and i have some large text fields that I am pulling
into the spreadsheet. IT will not set the rowheight larger than the 255
pixels and as a result there is text that is not visible on the sheet.
TIA,
Tom
Range("a2").Offset(GlobalCounter, j + 1).Rows.AutoFit