Hi every body,
I have a sheet called "date" which has names of customers in column "H". Putting into consideration that there is an input box in which I enter the name to be found.
I'm looking for (1)A macro to find all occurrences of a name in column "H" and (2)Another Macro to find the last occurrence of a name.
I tried this Macro, however it shows the first occurrence only.
any other suggestions on best practices of the code are appreciated
HTML Code:
Sorry, the sheet is called "Appointment"
what do you want to do with the names found?
you can write script to make a list on a sheet somewhere or an array of strings/address or a single delimited string.
To find the last one specifically just change SearchDirection:=xlNext to SearchDirection:=xlPrevious
Sub Reputation() Dim Problem as Variant Dim Reputation as Integer For Each Problem in Forum.Threads If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1 Next Problem End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks