View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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