LinkBack URL
About LinkBacks
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
Copy several columns width to another 2 sheets
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
As an example copy Columns A:E from Sheet1 to Sheet2
Please Login or Register to view this content.
Hope this helps.
Anthony
Pack my box with five dozen liquor jugs
PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?
Thank you very much smuzoen, that works
finally I make it like follow, but may be you have a better suggestion:
thanksPlease Login or Register to view this content.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks