Program was working fine, now im getting an error with "entire column.autofit"

this code keeps crashing on the line where I autofit the column.

it was working fine before..

Please Login or Register  to view this content.

I have attached my workbook.
The password, whenever prompted, is 'steel123'

Thanks!

Okay, now i'm really confused. I just saved the file so that I could post it on this forum, and when I went back to run it again, its working perfectly.

any ideas as to why that would happen?

Sorry, last post.

Its faulting when I add something obnoxious like "eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee"
and then try to delete it.

its having trouble autofitting after that I think because the column is so stretched out? i'm not sure.

I did a little more research and found this helpful thread: http://www.office-archive.com/2-exce...735b3692ea.htm

it's working now. hmmm.