Hey guys,
i have a macro that i would like to have loop through WED, THUR, FRI,SAT, SUN, MON, TUES on the attached sheet. Can someone help me with this? What its doing is deleting the yellow highlighted cells.
Please Login or Register to view this content.
Last edited by g1terra; 10-29-2017 at 11:30 PM.
hi there. you can try adding these code on top and below your running code:
you can also reduce some parts of your code. scrolling can all be deleted:Please Login or Register to view this content.
you can also combine some codes. when recording, you had to select the range before clearing.Please Login or Register to view this content.
it can also be done as:Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Ok that did not work it only clear the 1st sheet. I cleaned up my code and placed the in where you listed PLACE CODE HERE>
Here is My original..
Here is inserted in yours.. Not sure if I am doing something wrong?Please Login or Register to view this content.
OK that worked Alpha thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks