I am using Microsoft Excel 2013, and I want to select all cells that contain the value that is greater than a value. How do I do this ?
I have tried using Go To Specials, but it seems it is only able to select cells that have certain property such as blanks, have formulas or visible cells.
I have also found Microsoft Excel extension such as Ablebits, but it needs to pay, and I prefer the default function from excel.
Thankyou in advance.
One way is to run through all the data with a small macro.
Sub clean()
Dim r As Range, i As Integer
Set r = Range("A1:AE150")
Application.ScreenUpdating = False
Do
i = 0
For Each cell In r
If cell.Value >150000 Then
cell.Delete Shift:=xlUp
i = i + 1
End If
Next cell
Loop While i > 0
Application.ScreenUpdating = True
End Sub
Warning
The actions of a macro cannot be undone. Always save before running it to prevent the loss of data.
Note that this macro will fail if there are Tables involved
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments