• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to select the cells which have value less than certain number (let's say 100)

samtheman

New Member
Good Morning Geniuses,
How to select (not highlight) the cells which have value less than certain number (let's say 100)?

Thanking you,

Samtheman
 
Last edited:
Hi @samtheman!

First select the range that you want to verify, and later run this macro:
Code:
Sub SelectLessthan100()
  Dim c As Range, R As Range
 
  For Each c In Selection
      If c < 100 Then
        If R Is Nothing Then Set R = c Else Set R = Union(R, c)
      End If
  Next c
 
  R.Select
  Set R = Nothing: Set c = Nothing
End Sub

Blessings!
 
Hi again @samtheman!

I don't know any method without VBA for make selection with logic conditions instead equals (for example: equals to 100 you could do with Find and Replace).

You can use a Third-Party Add-in like Kutools or something like this... but those add-ins were programmed by VBA.

Blessings!
 
Back
Top