Excel Column or Cell word wrap?

[hockeyboi16]

Is there a way to set a column to have word wrap turned on through VBA?

 

[PHV]

Astarting point:
Range("A:A").WrapText = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hockeyboi16]

thanks very much!

 

[xlbo]

a good tip is to use the macro recorder to find these things out (Tools>Macros>Record New Macro)

This will allow you to set properties whilst "recording" the macro. After you are finished you can then look at the code generated and see how to reference the properties / methods you have used

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question