Macro using Vlookup to select a range dynamically according to data

Hey guys,

I'm new to this forum. I'm a beginner in VBA and have a problem I'm facing. I want to get stock prices from Book1 (Bhavcopy All) to Book2 (Final Scores) using vlookup. One column keeps getting added in Book 1, and I have to get that latest column into Book 2. When I was getting stuck with Object defined errors, I tried using record macro and getting some code. Now I've edited it to make the range dynamic, with the following code. The problem is in the vlookup function as I'm getting rng and LastColumn as text in the formula, instead of the actual numbers. Also I'm getting an error, Run time error '1004': Unable to get the VLookup property of the WorksheetFunction class. Any help would be appreciated.

Please Login or Register  to view this content.

code tags updated