• 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

    Hui...

  • 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

Aspur

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.
Code:
'Run Vlooukup in Colum H (cell h2) of Sheet "CompareToSchedule" (what the arugment is with wizard =VLOOKUP(D2,'GroupID''s '!B:H,7,FALSE)
    'Range("H2").Select
    'ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-4],'GroupID '!C[-6]:C,7,FALSE)"
    'Selection.AutoFill Destination:=Range("H2:H40000")
    'Range("H2:H40000").Select
How can I convert this code so that I can use a named range in the GROUPID sheet.
 
Top