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.
Next Application.ScreenUpdating = False Set rg = Intersect(Range("C:C"), ActiveSheet.UsedRange) For Each c In rg.Cells 'Only search column C Select Case c.Value Case "CT" 'Old value c.Value = "Y" 'New value End Select Next
|How to strip out formula but retain value in cell||2||23|
|Set WorkSheet not Working||9||38|
|Excel export Active Sheet in one workbook to a new sheet in another||8||23|
|VBA - Transfer values from Master wb to all wbs. Delete old data, copy new data from master wb to user wbs located in a folder.||3||14|