Error 2015 when trying to put vlookup into a cell

[sungsam]

I've written a small macro and everything was going fine until I tried to input a formula into a given cell, when the macro runs to this point I get a "Run-time error '1004': Application-defined or object-defined error" and when I check the line I've found that it gives me a "error 2015" which appears to be date related according to microsoft but that makes little sense to me.

Please Login or Register  to view this content.

I get the error on the last line of my code but strangly it doesn't happen if I cut it down to just "=(FM_ValExport!" & RA & ")".
Any suggestions are appreciated.

[Andy Pope]

What is the content of RA when the code fails?

Can you post workbook data example to better illustrate the errors?

[Cheeky Charlie]

What awful code.
I'm not going to rewrite it properly, but I think the problem is RA -
On creation, RA is an address (string which would look like "$A$1" or similar) - you're trying to insert it into a cell (I think activecell without definition uses .value) in which you're defining what looks like a formulaR1C1 reference.

[Andy Pope]

As per CC's suggestion, try this code to get correct notation of cell address.

Please Login or Register  to view this content.

[sungsam]

Awful code it might be, sadly that is all I can manage.

That does indeed work thanks Andy and CC.