AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 1,835
- Office Version
- 2019
- 2016
- Platform
- Windows
This is a bit weird. Inside a With-End With block I'm populating a cell
It's inside a For-Next loop where DAT changes to the appropriate column.
So all goes well until it gets to Col "R". Then it expands cell height to about 5 lines worth. Format Cells-Alignment and untick Wrap Text will correct this - but why does it do it?
I have set properties for Col "R" so Wrap text is Off, and other columns are nor doing this - only "R".
Is it perhaps the amount of text, the presence of linefeed, or something in the text turning it on ?
VBA Code:
.Cells(theLine, Dat) = v
So all goes well until it gets to Col "R". Then it expands cell height to about 5 lines worth. Format Cells-Alignment and untick Wrap Text will correct this - but why does it do it?
I have set properties for Col "R" so Wrap text is Off, and other columns are nor doing this - only "R".
Is it perhaps the amount of text, the presence of linefeed, or something in the text turning it on ?