Advertisement
Guest User

Untitled

a guest
Nov 12th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2.     $SearchTerm = "Question Sequence"
  3.     $Range = $ws.UsedRange()
  4.     $Match = $Range.Find($SearchTerm)
  5.     $First = $Match
  6.     Write-Host "        Reports at: " -NoNewline
  7.     Do
  8.     {
  9.         $MatchCell = $Match.AddressLocal($false, $false)
  10.         Write-Host "$MatchCell " -NoNewline
  11.         $Match = $Range.FindNext($Match)
  12.     } while ($Match -ne $NULL -and $Match.AddressLocal() -ne $First.AddressLocal())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement