Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
Due to the size of the data within the worksheet (80,000 rows, 62 cols) when the code gets to:
Dim aData As Variant aData = oSQLDataTbl.DataBodyRange.Value For r = 1 To UBound(aData, 1) For c = 1 To UBound(aData, 2) If Len(Trim$(aData(r, c))) = 0 Then ' the cell is blank aData(r, c) = "Null" Else If IsDate(aData(r, c)) Then If IsDate(Cells(r, c)) Then Cells(r, c).NumberFormat = "[$-409]m/d/yy h:mm AM/PM;@" If aData(r, c) < DateSerial(2011, 1, 1) Then aData(r, c) = "Null" End If End If End If Next c Next r
|Lock cells across workbook after data entry||10||48|
|VBA Excel Gantt||1||26|
|How to check if column "Assigned To" group was changed in SharePoint 2010?||18||26|
|Adding to a VBA?||6||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!