Wrap Text in Excel through VBA

How could i have Wrap Text feature while fulfilling text in Excel Cell through piece of VB code.
srikanthv2322Asked:
Who is Participating?
 
RobSampsonConnect With a Mentor Commented:
Hi, the WrapText property can be set on the ActiveCell using
ActiveCell.WrapText = True

Regards,

Rob.
0
 
nutschConnect With a Mentor Commented:
And to do a return in filling a cell via vba, you can use vbcrlf or chr(10), as in

[a1].value="string" & vbcrlf & "string 2"

Thomas
0
 
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0
All Courses

From novice to tech pro — start learning today.