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.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
For Each cell In rgsearch If IsError(cell.Value) Then xlws.Range(pbcol & cell.Row & ":" & pecol & cell.Row).ClearContents End If If Not IsNumeric(cell.Value) Or (cell.Value = "") Then 'Debug.Print cell.Row xlws.Range(pbcol & cell.Row & ":" & pecol & cell.Row).ClearContents End If If (cell.Value > 0) And (cell.Value <= 0.001) Then cell.Value = 0.002 End If If (cell.Value > 100) And (cell.Value <= 100.001) Then cell.Value = 100.002 End If If (cell.Value < 0) And (cell.Value >= -0.001) Then cell.Value = -0.002 End If If (cell.Value > 99.998) And (cell.Value <= 99.999) Then cell.Value = 99.998 End If Next cell
|Need help exporting Access table into multiple Excel worksheets||6||25|
|Export to Excel||7||32|
|Error can't find table ??||5||20|
|How to hide a listbox control (on a form) when the mouse moves away from the control||15||15|