Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, [M8:U65]) Is Nothing Then 'MsgBox Target.Address Dim lookFor As Range Dim rng As Range Dim col As Integer Dim found As Variant Dim ws As Worksheet Dim row As Integer Set ws = ActiveWorkbook.Sheets("Report") row = 10 Set lookFor = Sheets("Report").Range(Target.Address) Set rng = Sheets("Number and Operations").Columns("A:B") col = 2 On Error Resume Next found = Application.WorksheetFunction.VLookup(lookFor.Value, rng, col, 0) If IsError(found) Then MsgBox lookFor & " not found" Else: Range("L3").Value = found 'MsgBox "The look-up value of " & lookFor & " is " & found & " in column " & col End If On Error GoTo 0 Do ws.Cells(row, 1).Value = Range("L3") row = row + 1 Loop While row < 17 row = 10 End If End Sub
|Incorporating a number range, not cell range into search like 15271 - 15278||4||26|
|Excel sheet - Calculating 4 processors !||11||30|
|How to customise Office 2016 font settings with a GPO||3||27|
|Excel 2013 Drop down help with data||3||33|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!