Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.
Dim v As String
v = DoCompare(Range("Sheet2!C5").CurrentRegion, Range("Sheet5!D6").CurrentRegion)
If v <> "" Then MsgBox "Missing value(s): " & v
Function DoCompare(rng1 As Range, rng2 As Range) As String
Dim i1 As Long
Dim i2 As Long
DoCompare = ""
i2 = 1
For i1 = 1 To rng1.Rows.Count
If rng2.Cells(i1, 1).Text = "#N/A" Then
DoCompare = DoCompare & IIf(DoCompare = "", "", ",") & rng1.Cells(i1, 1).Value
Open in new window
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.
Premium members get this course for $159.20.
Premium members get this course for $167.20.
Premium members get this course for $62.50.
Premium members get this course for $148.75.
Premium members get this course for $174.99.
Premium members get this course for $79.20.