hi,
i am using below to auto file and set size of rows and column
but i want to apply this code to all sheets except two sheets 1 = "OF" and 2 = "haroon"
code is
thanxPlease Login or Register to view this content.
hi,
i am using below to auto file and set size of rows and column
but i want to apply this code to all sheets except two sheets 1 = "OF" and 2 = "haroon"
code is
thanxPlease Login or Register to view this content.
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
How can you possibly have gotten to 1324 posts in here without coming across 'for each sheet in sheets' before?
Like this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Perfect Bakerman2
thank you once again
u did, what i want
Another:
Please Login or Register to view this content.
@ HaroonSid
You' re welcome and thanks for rep+.
@ John
will go into debug since column A columnwidth is set to 0 by code.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks