VBA vlookup with variable for sheet reference

My apologies, I don't post on here very much, so please forgive my ignorance in posting.

I don't know if this is a syntax thing or what, but I'm getting an "Object doesn't support this property or method" error when it hits this line of code...

Please Login or Register  to view this content.

I want this formula entered in column CW on each sheet referred to in a loop, and on each sheet the vlookup will reference a different sheet, also indicated by a loop looking at a list. The loop seems to be working fine, just not the entering of this formula. I hope this makes sense because it sounds iffy to me. Thanks in advance for any help you can offer.

If wsLMPP is declared as as worksheet, you will need to use wslmpp.Name
But I suspect the formula is wrong & it should be

Please Login or Register  to view this content.

Thank you, that's perfect!!!

You're welcome & thanks for the feedback