Search Function Error on Duplicate Entries

[AbodeOfFelicity]

(Thanks in advance!!! ) Hello, I have a userform and I have a search button to search by "Last Name, First Name" - Normally it works well, but it gives the following error when there is more than one person (duplicate) with the same name and last name. (Name and last name are in the same cell)

Run-time error 1004
Method 'Range of object'_Global failed

When I click debug, it brings me to:
ListBox1.List = Range("SearchResults").Value

"SearchResults" is a named range, and it is the following:

=OFFSET(Name_Search!$A$6,0,0,COUNTA(Name_Search!$M:$M)-2,15)

Please Login or Register  to view this content.

[Pepe Le Mokko]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.(the "latest" today might not be the " latest" tomorrow)
Thanks

[AbodeOfFelicity]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.(the "latest" today might not be the " latest" tomorrow)
Thanks

Thanks, updated. Latest one, version 2003. (not year 2003)

[Pepe Le Mokko]

Just to be sure there is no confusion, you are still using XL2003 ?
I'm asking because recent versions have lots of functionalities 2003 does not have

[AbodeOfFelicity]

Just to be sure there is no confusion, you are still using XL2003 ?
I'm asking because recent versions have lots of functionalities 2003 does not have

No no, i'm using the latest excel. Excel 2020, Version 2003. Specifically, Version 2003 (Build 12624.20466)

[Pepe Le Mokko]

Ok, so update your XL version in your profile to 2020 ( the version as MS sees it is irrelevant as is the build). it will get you better help and help our members to help you.
Thanks for your patience

And BTW do not quote entire posts unnecessarily. Use the "Quick Reply" window instead

[bakerman2]

Please post an example file. Instructions on how to are in the yellow banner on top of the page.