Autofitting of columns not working as expected

Jeff,

I have just tried it with your suggested method as so:

Please Login or Register  to view this content.

...but am still not achieving a look where all of the columns are fitted properly. I went through each of the columns and it seems as though most of them are auto-fitted and three of them (including the widest one) are not. Double-clicking on the columns that aren't fitted still works fine, so I'm stumped as to why the VBA auto-fitting is not working.

Jeff,

Unfortunately, the workbook contains a considerable amount of sensitive information so I am not able to upload a sample at the moment. I did try running it using the two separate With..End With statements but achieved the same lack of results. I found a small number of other threads that had users with similar problems, but the only quasi-solution that I found (setting all column widths to a large value then auto-fitting) did not work either.

I also tried making a separate subroutine as follows and including it in the same module as the subroutine that creates the report:

Please Login or Register  to view this content.

If I run the above macro on its own, everything works perfectly, but if I call the subroutine in my main macro then it still does not work properly.

Jeff,

Any additional help would be greatly appreciated. If it helps, here is the code I currently have at the end of my macro after the report is generated (which shouldn't have any impact on whether or not auto-fitting works I would think) as well as the declarations I have for the variables included in that code:

Please Login or Register  to view this content.

There are no merged cells or wrapped text (both things that I have seen mentioned as preventing proper auto-fitting) anywhere on the report sheet and if I run the following macro with the sheet with the report active, the auto-fitting works exactly as it should.

Please Login or Register  to view this content.

It appears as though the issue was having screen updating disabled when the code attempted to auto-fit the columns. If the auto-fit code is ran after screen updating is enabled, it works as intended. This would also explain why running a separate set of code to auto-fit the columns worked independently.

Thanks Jeff and everyone else for the assistance.