Arindam_Bag
06-22-2012, 11:13 PM
Hi Experts,
I want to use variable column number in time of vlookup using VBA.
My code is
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC1,'[MS_Cellwise_NBH_raw kpi_March.xls]TCH Traffic'!C1:C256,a,0)"
Where a is variable.
But it is showing syntax error.
Please help.
Thanks in Advance.
Arindam Bag
India
I want to use variable column number in time of vlookup using VBA.
My code is
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC1,'[MS_Cellwise_NBH_raw kpi_March.xls]TCH Traffic'!C1:C256,a,0)"
Where a is variable.
But it is showing syntax error.
Please help.
Thanks in Advance.
Arindam Bag
India