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.
Bookmarks