I am working on a project where i need to adjust columns width based on data present. So, I also implemented below solution which is working without any issues.
Now the problem with this is VBA code is, In VM1 it’s working properly and in VM2 the script is not perfectly adjusting column width. Attaching sample output file generated by VM2.
I have tried using macros also, and i didn’t see any improvement and getting same output file as VBA script in VM2. Please let me know if you identified any issue or solution.
Test file.xlsx (34.3 KB)