View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Drew[_8_] Drew[_8_] is offline
external usenet poster
 
Posts: 1
Default 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