ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Autofit for entire sheet? (https://www.excelbanter.com/excel-programming/383670-autofit-entire-sheet.html)

Sonnich

Autofit for entire sheet?
 
I know this:

Worksheets("Results").Range("a1:c1").Columns.AutoF it

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


Tom Ogilvy

Autofit for entire sheet?
 
worksheets("Results").columns.Autofit

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

--
Regards,
Tom Ogilvy


"Sonnich" wrote:

I know this:

Worksheets("Results").Range("a1:c1").Columns.AutoF it

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




All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com