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...
 
Top