Hello:
I am new to this web site and hope that I have selected the right forum. If I have selected the wrong form please let me know where I should post this and I will do so.
I have a workbook consisting of 12 worksheets and each worksheet made up of many columns. As a result I find myself constantly having to select format and then auto fit. Having to do this so often is about to drive me nuts. I am hoping that someone can help me write a VBA that will cause the columns in the entire workbook to auto fit the column size each time I enter new data.
I should probably tell you that I am using Excel 2016 and that I am not experienced in using VBAs. About all I know is that I need to go to the developer tab and select visual basic. In my case, when I do that I get a box showing all the different worksheets and "this workbook." Further, I know that I can select any of the worksheets, but am guessing that since I want this to apply to the entire workbook that I would need to select "this workbook." Once making a selection I know that a window opens with two drop down boxes which I presume I need to make a selection from. What selections to make and how to write the VBA are beyond me. Can anyone please help me?
Thanks for your kindness,
Mark