how to use vb to control excel to auto fit the lines' width

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 5

how to use vb to control excel to auto fit the lines' width

To autofit row 3

Rows("3:3").EntireRow.AutoFit

"dark_wei" wrote in message
...

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Excel 2002: How to insert an Auto Fit Width button at the tool bar	Mr. Low	Excel Discussion (Misc queries)	2	July 4th 09 10:19 AM
How to control drop down list width	DocBrown	Excel Worksheet Functions	4	March 17th 09 06:03 PM
How can I control the full screen display width ?	Al B	Excel Discussion (Misc queries)	0	March 10th 07 07:53 PM
Control Bar Width with Graph Object	Mike C	Charts and Charting in Excel	1	January 17th 07 04:41 AM
Condensing Imported fixed-width text with multiple data lines to one Excel row	[email protected]	Excel Discussion (Misc queries)	1	August 5th 06 04:04 AM

All times are GMT +1. The time now is 09:35 PM.

About Us