I am trying to Vlookup and autofill a dynamic range.
My codes are as below
the Macro runs but it returns
Please Login or Register to view this content.
PBU ID
10014 #NAME?
Need help here so the macro auto fills coloum BPlease Login or Register to view this content.
Help Please
Sample attached
Last edited by ajay1967; 01-19-2012 at 08:04 PM. Reason: Forgot the rules for codes
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
With six posts you should know the rules.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Your code
To be changed asRange("B2:B" & LastRow).FormulaR1C1 = "= VLOOKUP(A2,Reference!A:B,2,0)"
Range("B2:B" & LastRow).Formula = "= VLOOKUP(A2,Reference!A:B,2,0)"
kvsrinivasamurthy'
Thank a lot it worked perfectly
Appreciate your effort.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks