Claire Jackson
Board Regular
- Joined
- Jun 30, 2020
- Messages
- 74
- Office Version
- 2016
- Platform
- Windows
Hi,
I have some basic code from a userform that populates a sheet in my workbook but when populating the worksheet the text in the cells aren't wrapping.
emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1
Cells(emptyRow, 1).Value = Textbox4.Value
emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1
Cells(emptyRow, 1).Value = "."
Range("A8:G200").WrapText = True
Can anyone help?
I have some basic code from a userform that populates a sheet in my workbook but when populating the worksheet the text in the cells aren't wrapping.
emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1
Cells(emptyRow, 1).Value = Textbox4.Value
emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1
Cells(emptyRow, 1).Value = "."
Range("A8:G200").WrapText = True
Can anyone help?