Recent content by AlAbba

Ok I will change the code and try it! Thanks xlbo!

Sorry xlbo, I didn't past the code.. Here it is! Sub FormatWSs() Dim sht As Worksheet Application.ScreenUpdating = False For Each sht In ThisWorkbook.Worksheets Select Case sht.Name Case "summary", "ePortfolio_IDAs", "E255", "ePortfolio_STMs" Cells.Select With...

Hi xlbo, Thank you for yor help. I have tried your code, but looks like there something wrong with my macro. It works without error, but it dosen't select the sheets. Here is the whole macro. Can you find out where is the mistake? Thanks

Hi Tony, You are right, but then how can I select all the worksheets, that could have different names, exept those 5 or 6 sheets. Please notice that I'm not a programmer, and the purpose of this macro is to format all the worksheet exept those 5 or 6 sheets. Many thanks for your help!

Hi Tony, Thank you for your prompt help. I hope I'm replying correctly! Hoever, I don't want to use select because all the sheets could be changed exept 5 or 6 sheets, and I want to exclude those sheets from the main bulk of the worksheets. Thanks

Hi everyone, I'm new to this forum, and I hope I can get help here. I'm working on an Excel macro that selects all the worksheets in a workbook exept a summary sheet. hoe can I exclude other worksheets in addition to summary? The code starts like this: For i = 1 To Sheets.Count...