Hi all,
If I have more than one occurrence of a word (say "Ford") in Col A (say A1, A5, A10, and A14) and I want (with VBA) to return the number of occurrences and the first and last cell addresses (ie 4 times and "A1" and "A14") can anyone point me in the right direction please?
Regards
Seamus
Hope this helps
Seamus
May have over thought these but
or
Please Login or Register to view this content.
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Many thanks for that vbanoob. I also meant to ask in my first question how I would go about deleting the occurrences in between 1st and last (ie A5 and A10).
Any help would be great?
Regards
Seamus
Maybe.
Change delete to clearcontents if required
VBA NoobPlease Login or Register to view this content.
Fantastic, vbanoob.
With a tiny bit of tweaking and combining the code works perfectly.
I may, of course, post again looking for further help with this project if I get stuck again.
Many thanks again
Seamus
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks