I want to code a Macro which runs through each data point in the two data validation lists which are on different sheets. Here's the code I wrote:

Please Login or Register  to view this content.

I am getting an error at line:
Please Login or Register  to view this content.

Error says "Method 'Range' of object '_Worksheet' failed, error 1004"

I know its a referencing error. But having a problem in figuring out the issue.

Thanks.