Autofit and sort on workbook close

Good morning,
I am trying to manipulate some worksheets during a Workbook_BeforeClose event. On sheet names that end with "sd" they need to alphabetize the data and autofit the columns. All sheets should hide on close, except "order". This is what I have but warning - it did something bad to my workbook. I can't get it back again. Had to force close Excel.

Please Login or Register  to view this content.

Thank you for any help. Most appreciated!!

Maybe:

Please Login or Register  to view this content.

Your main problem appears that for worksheets named as *sd it was not doing anything with them. The sort and autofit would always have been performed on what was the active sheet at the time.

You were also including all the cells in the worksheet in the sort, I've assumed your table in each worksheet starts in cell A1 and is a contiguous block of data.

Dom

You missed one:

Please Login or Register  to view this content.

Originally Posted by romperstomper

You missed one:

Please Login or Register  to view this content.

Indeed I did, thanks.

Dom

Thank you, Domski and romperstomper. I appreciate the help but it's still autofitting the "order" sheet and it shouldn't. It will be the active sheet on the close event but the name is just "order", not "*sd", so it shouldn't autofit.
(Thank you for the advice too. I'm still learning and telling me where I went wrong is most helpful.)

It's also sorting my header columns into the data. I changed the range to "A2".CurrentRegion. Still didn't help. Thanks .......

Are you sure you don't have some other code that's doing that to the Order sheet as what I have posted definitely won't.

Dom

Try changing this line:

Please Login or Register  to view this content.

Dom