Indenting 2nd line of word wrap

[Coach3131]

How can I set the 2nd line of a word wrapped merge cell to indent? I know the manual way, by using alt enter for each line, but is there a way to do it with VBA script, etc.?

 

[asking]

Try this ~

ActiveCell.FormulaR1C1 = "Now try this." & Chr(10) & "It works."


The Chr(10) creates the line wrap. An indent is different and will not do what I think you require.

Cheers

 

[Coach3131]

What makes this automatic? If I am going to do something manual, there is already a way to do it. I need something that will add an indent to the 2nd (or 3rd/4th/etc.) lines.

 

[Coach3131]

Following up on this...