I am not sure I understand what you mean, but you could add something like below at the end of your code
Cells.Select Cells.EntireColumn.AutoFit
I am not sure I understand what you mean, but you could add something like below at the end of your code
Cells.Select Cells.EntireColumn.AutoFit
------------------------------------------------
Thanks For All Your Help
Windows 7
Excel 2010
Any codes I provide please try on a copy of your workbook first as these cannot be undone!
To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.
The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.
Posting Permissions
Reply With Quote