• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Converting VBA recorded macro to written macro


New Member
Hello All

I am new to VBA. Most of my experience has been to record macros and then tweak them when they are simple. I am trying to convert a Vlookup recorded macro to one that is more dynamic with a named range.
'Run Vlooukup in Colum H (cell h2) of Sheet "CompareToSchedule" (what the arugment is with wizard =VLOOKUP(D2,'GroupID''s '!B:H,7,FALSE)
    'ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-4],'GroupID '!C[-6]:C,7,FALSE)"
    'Selection.AutoFill Destination:=Range("H2:H40000")
How can I convert this code so that I can use a named range in the GROUPID sheet.