invalid next control error

[pjmsimmons]

Hi All,
Hoping someone can help. I am very new to VBA programming and am trying to write a macro which compares two lists (comparerange1 and 2) and if it finds a match takes a value from two columns over in comparerange1 and enters it into the first available row f column F in a specified worksheet. I have copied the macro below which I've pasted from varous examples I've found. I'm getting an invalid next control error at the next Y line. Can anyone help me figure the problem. Hope its an easy one!


Code:

Please Login or Register  to view this content.

Cheers
Paul

nb code tags now added.

[rylo]

Paul

you are missing the next statement for the wsSheet loop.

Also, can you please edit your post and attach the code tags.

rylo

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here