Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
Sub lee() Dim leeName As String Dim count As Integer count = 0 With ActiveSheet.Range("A1") Do Until .Offset(0, 0).Value = "" leeName = .Offset(0, 0).Value If Len(leeName) >= 4 Then If Right(leeName, 3) = "LEE" And Mid(leeName, leeName, (3 - 1)) = " " Then count = count + 1 End If End If Loop End With MsgBox = "There are " & count & " people whose last name is Lee." End Sub
|From Excel how can I import data from SSRS Reporting Services ?||6||27|
|excel - employee availability remaining after scheduled||7||34|
|Have the left number set as a countdown on days that are passing by.||19||28|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!