Hi everyone
does anyone know any code that will change a cell width and height .
Hi everyone
does anyone know any code that will change a cell width and height .
Last edited by jakeembx; 01-13-2014 at 03:30 PM.
Hi Jake,
If I turn on my macro recorder and make the Column wider and Row taller I get code like:
Columns("B:B").ColumnWidth = 10
Rows("3:3").RowHeight = 23
I hope that is enough help to do what you need.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Something like:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
You must resize the row and the column of the cell :
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
thanks guys solved my problem!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks