VBA Errors

[ryan.wherry]

I've been using the same workbook for a couple of years now. it contains a lot of Userforms and coding. recently, I have been running into a lot of errors that I never had before. mostly with column resizing, changing fonts, and worksheet zooming all done by code. it doesn't seem to be specific to this single workbook, so I don't believe the workbook is corrupt. if i kill the excel process and restart the workbook, it works fine for awhile. I've tried repairing the office installation, but still having issues. any thoughts?

[6StringJazzer]

The focus of your post is that you are getting errors, but you have not described what those errors are. Do you mean that it's resizing, changing fonts, and zooming but it's not supposed to? Or are those the normal things that your code is doing? Can you elaborate on what it's supposed to do, and what it's actually doing instead?

[ryan.wherry]

sorry. I want the workbook to autosize, zoom and change fonts through code. but I occasionally get errors when the code runs. example: Autosizing column: I get this error: Run-Time Error '-2147417848 (80010108)': Method 'AutoFit' of object 'Range' Failed. this use to never happen. but now I have to reopen the workbook 2-3 times a day for it to run properly.

[6StringJazzer]

The "occasionally" part makes it hard. Can you attach your file to see if we can reproduce the errors?