I have reseached this problem for 5 days to no avail. Lots of great suggestions but nothing has worked. I am fairly new to VBA and running Office 2010 and am dumping information from a query into an excel file and perform formatting via VBA. The first time I run the code it works perfectly...