Formatting with Macros Excel 2003

[captphan]

When ever I format using a Macro in Excel 2003, Excel crashes when I save the file. Has anyone else run into this and no of a work around.


I am glad I don't know it all because then I would be bored.
-Obie

 

[GlennUK]

What formatting are you doing? What kind of crash happens? Any messages?



Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

Please post your code also. Might be more appropriate in Forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[captphan]

I save succesffuly before

    Cells.Select
    Cells.EntireColumn.AutoFit

The only error message is
Micrsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience.



I am glad I don't know it all because then I would be bored.
-Obie

 

[SkipVought]

First of all, Cells on WHAT sheet?

Then, why select?

Better to do it this way.

   Sheets("TheSheetNameThatYouWantToAutoFit").EntireColumn.AutoFit

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

oops

Sheets("TheSheetNameThatYouWantToAutoFit").Cells.EntireColumn.AutoFit

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[GlennUK]

Personally I would do an autofit on the entire sheet, just the UsedRange:

Sheets("TheSheetNameThatYouWantToAutoFit").UsedRange.EntireColumn.AutoFit

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[GlennUK]

Read "would" as "wouldn't" .

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[captphan]

Excellent thank You

I am glad I don't know it all because then I would be bored.
-Obie