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.
How can I convert this code so that I can use a named range in the GROUPID sheet.
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.