Log In
Register
Home
Find first match cell that contains specific char
Alan O
New Member
Members
Forum Posts: 1
Member Since:
June 16, 2018
June 16, 2018
Offline1
June 16, 2018 - 8:11 am
Data that I have in a column F are:
| ??? spelling :37:11 PM ++++ |
| ??? What is this ++++ Created by:system (System) at 5/21/18 3:37:12 PM ++++ |
| ??? Hello World ++++ Created by:system (System) at 5/21/18 3:37:11 PM ++++ |
| ++++ Created by:system (System) at 5/21/18 2:33:30 PM ++++ |
| ++++ Created by:system (System) at 5/21/18 2:33:30 PM ++++ |
How do I locate the first cell that starts with ++++, in this case, row 4, then from there Select the entire row (ie. col A to F) then all rows below it and delete.
Hope that's clear.
Thanks.
SunnyKow
Puchong, Malaysia
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016
Offline2
June 18, 2018 - 2:43 am
Hi Alan
Give this a try.
Sub DelRow()
Dim FirstRow As Long
Dim LastRow As Long
FirstRow = Application.Match("++++*", Range("F:F"), 0)
LastRow = Cells(Rows.Count, "F").End(xlUp).Row
Rows(FirstRow & ":" & LastRow).Delete Shift:=xlUp
End Sub
Sunny
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria, Lionel Baijot, Jack Brett, Ben Hughes
Guest(s) 12
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Hayden Hao
Angela chen
Sean Moore
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Ray-Yu Yang
George Shihadeh
Naomi Rumble
Forum Stats:
Groups: 3
Forums: 24
Topics: 6211
Posts: 27239
Member Stats:
Guest Posters: 49
Members: 31891
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —