just use record macro in the dev tab when you do it and set a shortcut
just use record macro in the dev tab when you do it and set a shortcut
![]()
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
thanks for the advice. I could do this but I'd still have to run the macro every time. I want it so that as soon as I paste in the data, the data is populated in a different column without duplicates. is this possible?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks