Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Sheets("Report").Select Range("A27").Select ActiveSheet.Shapes.AddChart.Select ActiveChart.ChartType = xlColumnClustered ActiveChart.SetSourceData Source:=Sheets("Pivot Table Data").Range("A25:B42") ActiveChart.Legend.Select Selection.Delete ActiveChart.SetElement (msoElementChartTitleAboveChart) ActiveChart.ChartTitle.Text = "% of Time" ActiveChart.Axes(xlValue).Select Selection.TickLabels.NumberFormat = "0%" ActiveChart.SetElement (msoElementDataLabelOutSideEnd)
|Pivot a table with 3 coulmns with two layers of header columns||3||34|
|Excel formula to show $0.00 if negative number.||7||53|
|adding "ungroup sheets" to existing vbs code||5||30|
|Excel 2010 Pivot Table Calculated Fields||2||12|