EXCEL - Column width

D

Don

Is there any way to set a column's width based upon one
cell, not the whole column? I have thought of using the
number of characters displayed as a base, but what eles?

Thanks,
Don
 
T

Tushar Mehta

Range("F2").Columns.AutoFit
adjusts column F so that it just contains the conetents of F2. If some
other cell, F3 for example, require more space, it will continue to
overflow into the next column (or be truncated if G3 is not empty).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
D

Don

Much thanks, it worked.
Don
-----Original Message-----
Range("F2").Columns.AutoFit
adjusts column F so that it just contains the conetents of F2. If some
other cell, F3 for example, require more space, it will continue to
overflow into the next column (or be truncated if G3 is not empty).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions


.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Excel Column Width in XLSX 0
Excel does not accept text format! 0
Mail Merge Directory Conditional Page Break 0
Table Preferred width is changed when pasting 1
Autonumber field in Excel that behaves the same as Access 0
Dealing with a Pivot Table (when I don't want to) 0
VBA - (re-) Set a Table Style 2

Top