Excel: Help with Indexing in VBA

Hello, I am not able to figure out, what is wrong in this Indexing code.

Range("R6").Select ActiveCell.FormulaR1C1 = "=IF($Q6="","",INDEX('Worker-Exempt'!B:B,MATCH($Q6,'Worker-Exempt'!A:A,0)))"
I get application 1004 error msg. Cross Posting [HTML]http://www.excelforum.com/excel-programming-vba-macros/960412-vlookup-to-index-matching-in-vba.html[/HTML]

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of October 10, 2013.

For more resources for Microsoft Excel