Drawing borders with Macro
I am reworking an existing Excel schedule to reflect some administrative
changes. I have done all of the major work, but I made a mistake while
doing it. The schedule has columns for each day, then rows for each
employee. If the employee works, there is a 1 in the cell for the
corresponding day, if not there is an X. Each work week is divided by a
bold border, so that it is easy for the timekeepers to see when the work
week ended. When I initially sectioned out the work weeks, I made the bold
border between Saturday and Sunday, but alas, the work week runs from Wed to
Tue. Now I need to change all of this, and I thought maybe a macro could
help out.
How can I build a macro to draw borders between T and W?
Thanks,
Drew
|