PC Review


Reply
Thread Tools Rate Thread

Autofit for entire sheet?

 
 
Sonnich
Guest
Posts: n/a
 
      21st Feb 2007
I know this:

Worksheets("Results").Range("a1:c1").Columns.AutoFit

But I want it for the entire document.... basically I know "c" as a
number, but I dont know the row count.

What properties can I use (which I cannot find in the help)

/S

 
Reply With Quote
 
 
 
 
=?Utf-8?B?VG9tIE9naWx2eQ==?=
Guest
Posts: n/a
 
      21st Feb 2007
worksheets("Results").columns.Autofit

for rows
worksheets("Results").Rows.autofit

--
Regards,
Tom Ogilvy


"Sonnich" wrote:

> I know this:
>
> Worksheets("Results").Range("a1:c1").Columns.AutoFit
>
> But I want it for the entire document.... basically I know "c" as a
> number, but I dont know the row count.
>
> What properties can I use (which I cannot find in the help)
>
> /S
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying one entire row from a source sheet to a destination sheet Russ Microsoft Excel Programming 2 30th Sep 2009 07:16 PM
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. bertbarndoor Microsoft Excel Programming 4 5th Oct 2007 04:00 PM
Sheet Protection, Hidden Columns, and Autofit =?Utf-8?B?U3RlcGhlbg==?= Microsoft Excel Programming 5 5th Apr 2007 03:24 PM
How do I Embed an entire excel spread sheet from entire file. =?Utf-8?B?Sm9lbA==?= Microsoft Outlook Discussion 0 28th Sep 2005 12:07 AM
Copy the entire sheet to overlay existing sheet? LurfysMa Microsoft Excel New Users 2 29th Aug 2005 07:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:48 AM.