Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.
I guess Log10 is wrong but how to correct it?
Option Explicit Sub Convert() Dim r1 As Range Dim varData Dim x As Long, y As Long Application.ScreenUpdating = False Set r1 = Sheet1.Range("E2", "Z70") varData = r1.Value2 For x = 1 To UBound(varData, 1) For y = 1 To UBound(varData, 2) If IsNumeric(varData(x, y)) And x Mod 3 <> 0 Then varData(x, y) = -1 * Application.WorksheetFunction.Log10(varData(x, y)) End If Next y Next x r1.Value2 = varData Application.ScreenUpdating = True End Sub
|Incorporating a number range, not cell range into search like 15271 - 15278||4||25|
|Excel 2013 Drop down help with data||3||31|
|Tricky lookup and concatenate formula||6||28|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!