<RESOLVED> Justify text in cell

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.

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

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

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.

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 :)

Doh!
The secret is out ;-)

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

VB Code:

range("a1:c4").[B]wraptext[/B] = [B]true[/B]

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

Y.

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