Copy several columns width to another 2 sheets

[ruliansyah]

Hello again,
here's another question from me
I have let say 5 sheets in a workbook and I want to copy columns width from 1 sheet to another 2 sheets, how to do that using macro?? I don't want to use autofit with the code anyway.
Thanx

[smuzoen]

As an example copy Columns A:E from Sheet1 to Sheet2

Please Login or Register  to view this content.

[ruliansyah]

Thank you very much smuzoen, that works
finally I make it like follow, but may be you have a better suggestion:

Please Login or Register  to view this content.

thanks

[smuzoen]

The only comment would be is that there is no need to activate or select in the loop above - I cannot see that as being required so you could remove this. Sheets do not have to be active or selected to effect a copy command as long as the correct sheet is referenced which you have done in your code.

[ruliansyah]

well, I just want the selection to be cleared when finish, I don't like the grey area left after the macro is done .

thank you again for your suggestion master smuzoen, you're the man.