Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions

Harlan Grove[_2_] Harlan Grove[_2_] is offline

external usenet poster

Posts: 1,231

Altered Column Width

"Don Guillett" wrote...
Refresh with a macro that has one line to reset the column width

columns(5).columnwidth=12
....

Or store the column width in a variable first, import into the column,
then restore the saved column width.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Altered Column Width	No Name	Excel Discussion (Misc queries)	2	May 4th 07 06:08 PM
Altered Column Width	No Name	New Users to Excel	2	May 4th 07 06:08 PM
Altered Column Width	No Name	Excel Worksheet Functions	2	May 4th 07 06:08 PM
Set Column Width Based On Total Width Of Other Columns	rayneraingoaway	Excel Programming	1	June 28th 06 11:10 PM

All times are GMT +1. The time now is 07:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us