The data in my sample sheet has been sorted by dates (Column G). I would like to insert a blank row between the rows where one weeks ends and another begins. I need VBA code because this will be appended to a larger macro I am working on.
The data in my sample sheet has been sorted by dates (Column G). I would like to insert a blank row between the rows where one weeks ends and another begins. I need VBA code because this will be appended to a larger macro I am working on.
Last edited by Wedge120; 11-27-2014 at 12:40 AM.
Try this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Can you explain this line in layman's terms?
Please Login or Register to view this content.
The code works well, btw.
Well - that means that if the absolute value of the difference in date (which is the number of days between the dates) is more than two - Glad it's working
Thanks for the rep!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks