Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
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.
Sub Pivot1() Columns("A:A").Select Sheets.Add ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Open Orders!R1C1:R1048576C1", Version:=xlPivotTableVersion12). _ CreatePivotTable TableDestination:="Sheet5!R3C1", TableName:="PivotTable8" _ , DefaultVersion:=xlPivotTableVersion12 Sheets("Sheet5").Select Cells(3, 1).Select With ActiveSheet.PivotTables("PivotTable8").PivotFields("SOSOLN") .Orientation = xlRowField .Position = 1 End With ActiveSheet.PivotTables("PivotTable8").AddDataField ActiveSheet.PivotTables( _ "PivotTable8").PivotFields("SOSOLN"), "Count of SOSOLN", xlCount
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.