$$Excel-Macros$$ Differentiating bars on a stacked bar graph based on dates

We have a stacked bar graph that displays 26 4-week periods spanning two years. The requesting department would like to differentiate the colors on the bars for the past year from the colors on the bars for the current year. This is using Excel 2003. When I try to edit the colors for the graph the

$$Excel-Macros$$ Need to find the second to final row in order to copy detail lines

This macro works fine for copying and pasting totals: Sub Copy_Paste_Totals() ThisWorkbook.Worksheets("Sheet2").Select Dim LastRowTotal As Integer ThisWorkbook.Worksheets("Sheet2").Select LastRowTotal = Range("B65536").End(xlUp).Row ThisWorkbook.Worksheets("Sheet2").Select

$$Excel-Macros$$ VBA Macro to automatically set a print area

We have a requirement to run a templated output for a WebFocus report that include the capability to have the output ready to print. In other words, a user should be able to see the exact printout available when the Excel opens by clicking on "Print Preview". Issues: 1.) The output can be anywa