Compile Error: Invalid Outside Procedure Error

[pschris]

Hi everyone,

I'm trying to run the below code, but run into the title error, highlighting "xlUp" in the third line. When I replace Potato2 with LastRow and a with i for the variables, the code runs fine. I'm not very knowledgeable about variables, so any advice with those would be great. Thanks!

Please Login or Register  to view this content.

[AB33]

There is nothing wrong with the code.
Potato2 is not defined in the code, you need to do the same as you did with the last row. The code will not run if Potato2 is nothing.

Please Login or Register  to view this content.