Posted to microsoft.public.excel.programming

Elena

external usenet poster

Posts: 43

autofit

I'm trying to get data to fit an excel row. I tried to use the autofit
method, but it si not working. This is my code:

CoverWs.Range("a1").WrapText = True
CoverWs.Range("a1").EntireRow.AutoFit()

Can someone tell me how to fix it?

Thanks in Advance!
~Elena

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
Autofit (Columns.EntireColumn.AutoFit) does not work	Michiel via OfficeKB.com	Excel Discussion (Misc queries)	3	February 10th 09 05:29 PM
autofit does not autofit	rreneerob	Excel Discussion (Misc queries)	1	October 17th 05 05:55 PM
Autofit	kevin	Excel Programming	3	October 4th 04 09:26 PM
AutoFit	TanahAirShah	Excel Programming	1	January 16th 04 10:04 PM
row autofit	Robin Hammond	Excel Programming	0	September 6th 03 02:33 AM

All times are GMT +1. The time now is 10:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us