×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

VBA using Excel (If Statement) please help!!!

VBA using Excel (If Statement) please help!!!

VBA using Excel (If Statement) please help!!!

(OP)
I need help

I am trying to make an if statment that deletes the entire row if a cell's value in that row is less than 100.

Example: I have a list of people with all sorts of information on them in separate columns, age is one of the columns.  I want to delete the person or row if that person is, lets say, under the age of 100.

RE: VBA using Excel (If Statement) please help!!!

Put a command button on the sheet and use something like:

Private Sub CommandButton1_Click()
Dim myrange As Range
Dim myrange2 As Range
Dim rowcounter As Long
Set myrange = Worksheets("Sheet1").Range("A1:c100")
For rowcounter = 100 To 1 Step -1
    If myrange.Cells(rowcounter, 2).Value > 50 Then
        Set myrange2 = myrange.EntireRow(rowcounter)
        myrange2.Delete
    End If
Next
End Sub

Where the 2 is the column you are testing

RE: VBA using Excel (If Statement) please help!!!

aordoqui,

Did it work OK for you?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources