ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Compare2Lists" Macro Not working (https://www.excelbanter.com/excel-discussion-misc-queries/3218-%22compare2lists%22-macro-not-working.html)

B Schwarz

"Compare2Lists" Macro Not working
 
I am trying to use the "Compare2lists" macro and it is giving me the error...

Named argumet not found in line

MatchCase:=True,Search

under

Sub Extract Uniques_Duplicats()


Can anyone help??
Barb

Dave Peterson

You may want to post where you got the macro.

(I don't recognize it.)

Well, I searched google and got a couple of hits.

This one had an alternate suggestion by keepitcool that the poster liked:

http://google.co.uk/groups?threadm=u...gp13.phx .gbl


B Schwarz wrote:

I am trying to use the "Compare2lists" macro and it is giving me the error...

Named argumet not found in line

MatchCase:=True,Search

under

Sub Extract Uniques_Duplicats()

Can anyone help??
Barb


--

Dave Peterson

B Schwarz

Dave,
I got it from a post here in the Microsoft Discussion group. But the post
you linked me to at Goggle was the same post.
Any Ideal who Cecil is or why this macro wont work??

"Dave Peterson" wrote:

You may want to post where you got the macro.

(I don't recognize it.)

Well, I searched google and got a couple of hits.

This one had an alternate suggestion by keepitcool that the poster liked:

http://google.co.uk/groups?threadm=u...gp13.phx .gbl


B Schwarz wrote:

I am trying to use the "Compare2lists" macro and it is giving me the error...

Named argumet not found in line

MatchCase:=True,Search

under

Sub Extract Uniques_Duplicats()

Can anyone help??
Barb


--

Dave Peterson


Dave Peterson

I didn't look at his code. But I did notice that the OP responded that
KeepItCool's suggested alternative did.

B Schwarz wrote:

Dave,
I got it from a post here in the Microsoft Discussion group. But the post
you linked me to at Goggle was the same post.
Any Ideal who Cecil is or why this macro wont work??

"Dave Peterson" wrote:

You may want to post where you got the macro.

(I don't recognize it.)

Well, I searched google and got a couple of hits.

This one had an alternate suggestion by keepitcool that the poster liked:

http://google.co.uk/groups?threadm=u...gp13.phx .gbl


B Schwarz wrote:

I am trying to use the "Compare2lists" macro and it is giving me the error...

Named argumet not found in line

MatchCase:=True,Search

under

Sub Extract Uniques_Duplicats()

Can anyone help??
Barb


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 01:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com