ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I set all Column widths 25? (https://www.excelbanter.com/excel-programming/389199-how-can-i-set-all-column-widths-25-a.html)

Jack

How can I set all Column widths 25?
 
Thanks in advance!!!

Jack

merjet

How can I set all Column widths 25?
 
Columns("A:IV").ColumnWidth = 25

Merjet



Jack

How can I set all Column widths 25?
 
Thank you very much!!!

Would you know how to right justift all columns?

Thanks again for you help,

Jack

"merjet" wrote in message
ups.com...
Columns("A:IV").ColumnWidth = 25

Merjet




Dave Peterson

How can I set all Column widths 25?
 
Sometimes, recording a macro when you do it manually will be quicker than asking
and waiting for a response.

I usually open a new workbook and then record a macro in that workbook's
project. Then I copy|paste to its real home.


Jack wrote:

Thank you very much!!!

Would you know how to right justift all columns?

Thanks again for you help,

Jack

"merjet" wrote in message
ups.com...
Columns("A:IV").ColumnWidth = 25

Merjet



--

Dave Peterson


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

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