Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Sub x() Dim rFind As Range, sAddr As String With Sheet1.Columns(10) Set rFind = .Find(What:="Sel", LookAt:=xlWhole, MatchCase:=False, SearchFormat:=False) If Not rFind Is Nothing Then sAddr = rFind.Address Do rFind.Offset(, 5) = -1 * rFind.Offset(, 5) Set rFind = .FindNext(rFind) Loop While rFind.Address <> sAddr End If End With End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|vba code to create folders according to a hyperlink||14||41|
|Excel Auto-Complete lines||4||32|
|Userform to show a range in excel.||3||33|
|Records being deleted when Condition Not Met||30||28|
Join the community of 500,000 technology professionals and ask your questions.