ExcelBanter - Best Fit Column Width

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Best Fit Column Width (https://www.excelbanter.com/excel-programming/317318-best-fit-column-width.html)

jtrevill[_5_]

Best Fit Column Width

Anyone know how using VB to resize the column width to the best fit?

Thanks for the help!

--
jtrevill
------------------------------------------------------------------------
jtrevill's Profile: http://www.excelforum.com/member.php...o&userid=16601
View this thread: http://www.excelforum.com/showthread...hreadid=316940

Norman Jones

Best Fit Column Width

Hi JTrevill

Try something like:

ActiveCell.EntireColumn.AutoFit

---
Regards,
Norman

"jtrevill" wrote in message
...

Anyone know how using VB to resize the column width to the best fit?

Thanks for the help!

--
jtrevill
------------------------------------------------------------------------
jtrevill's Profile:
http://www.excelforum.com/member.php...o&userid=16601
View this thread: http://www.excelforum.com/showthread...hreadid=316940

All times are GMT +1. The time now is 11:03 PM.