I have the following macro below to clear data from B24 to the last col containing Data
Please Login or Register to view this content.
It would be appreciated if someone could improve the code, although it works
I have the following macro below to clear data from B24 to the last col containing Data
Please Login or Register to view this content.
It would be appreciated if someone could improve the code, although it works
Obvious question: why? What do you mean by 'improve'?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
One way.
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.
what I meant is to make the code look neater I.E. tidy the code
But why? What's not neat about it? Who is going to be looking at it other than you?
Don't waste time on aesthetics when they don't matter: if it ain't broke ...
Similar to bakerman2
Please Login or Register to view this content.
@ Ali
Using Select, Selection is a textbook example of poor coding and is to be avoided as much as posssible.
Keeping that in mind code can be 'improved' or tidied.
Thanks for the help
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks