<RESOLVED> Justify text in cell

[yorch]

Hi all,

What is the command to align text in a cell but not to left or right, I mean to distribute the text and making the cell height bigger.

Thanks in advance,

Y.

[Static]

Columns("A:A").ColumnWidth = [NUMBER.. ex: 25]

Range("A1").HorizontalAlignment = xlCenter
there is also
xlFill and xlJustify, but they didnt seem to do anything?

[VBAhack]

The best way to figure out things like this is to use the macro recorder - start the recorder, perform the tasks you want, stop the recorder, then look at the resulting code.

[Static]

VBAHack!! dont tell them that! c'mon! it makes us seem so smart that we can figure stuff out soooo easily :) lol

Macros are your friend :)

[DKenny]

Doh!
The secret is out ;-)

[yorch]

Thanks all!, actually a friend told me about the macro recorder (something unknown for me) and there I found the exactly answer.

range("a1:c4").wraptext = true


jejeje, secret revealed. May be you will see me more often answering questions ;)

Y.

[VBAhack]

Oops. I guess I'll be forever ostracized..... :eek: