LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 390
Default Apply Border based on last Day of Month

I have a spreadsheet that list three months of dates. Row 3 list the day for
each month. Example

B3 = 1
C3 = 2
D3 = 3
E3 = 4......And so on...
eventually CO3 = 31

I need to accomplish two tasks using VBA for Excel.

1. I need to apply a verticle line to the right side of the column when it
equals the last day of the month. As an example... If the starting month is
Feb 05, then a thick border would be applied to the right side of colum AC
because AC3 contains the last day of the month (28) for Feb. Columns BH and
CL would also have a thick border applied to the right side since BH3 and CL3
contain the last working day for those months.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to apply filter based on list or combo box?? Jon Excel Discussion (Misc queries) 1 May 13th 09 01:01 PM
add a border based on value in cell Earl Cobb, Instructor Excel Worksheet Functions 2 March 2nd 07 01:50 PM
Changing the border of one cell s/n change the border of adjacent gjanssenmn Excel Discussion (Misc queries) 2 October 5th 05 08:35 PM
Apply cell shading based on adjacent cells in EXCEL garywr Excel Worksheet Functions 3 September 10th 05 01:35 PM
Add border based on date Bardo Excel Programming 2 April 8th 04 04:39 PM


All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"