Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Troubling saving in Excel 2003 after Formatting with a Macro

Status
Not open for further replies.

captphan

Programmer
Jan 24, 2007
42
When ever I format
Code:
Cells.Select
Cells.EntireColumn.AutoFit
using a Macro in Excel 2003, Excel crashes when I save the file.

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

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
 




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

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top