ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hOW DO i CHANGE COLUMN WIDTH FOR ONLY A SELECT RANGE OF CELLS? (https://www.excelbanter.com/excel-discussion-misc-queries/45329-how-do-i-change-column-width-only-select-range-cells.html)

RCONLON_291

hOW DO i CHANGE COLUMN WIDTH FOR ONLY A SELECT RANGE OF CELLS?
 


Anne Troy

You can only change the entire column's width. A column cannot have two
widths, tho you may be able to emulate it using merged cells.
************
Anne Troy
www.OfficeArticles.com

"RCONLON_291" wrote in message
...




Jim May

activesheet.columns("D:G").columnwidth = 3

"Anne Troy" wrote in message
...
You can only change the entire column's width. A column cannot have two
widths, tho you may be able to emulate it using merged cells.
************
Anne Troy
www.OfficeArticles.com

"RCONLON_291" wrote in message
...







All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com