Application defined error with VBA formula using name of tab in formula

Hi - getting Runtime Error 1004 - application defined or object defined error on

ActiveCell.FormulaR1C1 = _

"=VLOOKUP(" & InvestorID & ",'CapCall Mgmt Fee Temp'!C2:C12,4,0)"

below. The InvestorID I am using the name of the tab which is 12366XY. Once I get this squared away I want to run this through each tab, that has a tab name ending with "XY".

Any help with current error would be appreciated.

Thanks

Please Login or Register  to view this content.

Appreciate the response!

The C is representative of columns so its referring to Columns 2 through columns 12.

It has something to do with the name of the tab although I can not figure out what.

What I change the formula to have the actual name of the tab in the formula it works.

ActiveCell.FormulaR1C1 = _

"=VLOOKUP(""12366XY"",'CapCall Mgmt Fee Temp'!C2:C12,4,0)"

any other thoughts?

Thanks

Figured it out. Needed more quotation marks

ActiveCell.FormulaR1C1 = _

"=VLOOKUP(""" & InvestorID & """,'Mgmt Temp'!C2:C12,4,0)"

Thanks