WrapText for a column without changing values

[anthonylatona]

Hey everyone!

I'm trying to execute something like this:

msdn.microsoft.com/en-us/library/office/ff821514(v=office.15).aspx

but without changing the cell value... I basically want a button that will wrap/unwrap all of the cells in the "B" column with one click. If i have to do the cell range for every individual cell in column B that's fine, but I can't seem to make the above example work while keeping the cell contents the same.

Thanks!

 

[Gavin T]

Try

Columns("B").WrapText = True

 

[anthonylatona]

Thanks Gavin!!

So, this is the best forum I've ever joined.

Amazing! Thanks again!!

 

[Gavin T]

You're welcome.