I'm trying to use WorksheetFunction.lookup in some VBA code. I can get the following to work
So if I try to switch it out for a cell value like below
I know that the counter is fine because I am using it in the same block of code. Is there a way I can use a variable with WorksheetFunction.lookup?