Forum Discussion

Copper Contributor

Mar 24, 2020

VBA Runtime Error 1004 while assigning formula to a cell

I have created a small macro to apply a currency conversion with a fixed factor on selected cells. Sub ApplyUSD_ConversionRate() ' ' Devides through USD_ConversionRate on selected cells ' ...

excel

Macros and VBA

JKPieterse

Silver Contributor

Mar 24, 2020

In this case you could use cel.FormulaLocal instead of cel.Formula. That will ensure Excel does not take the comma in your decimal number to be a thousand separator (VBA speaks American)

Michael63

Copper Contributor

Mar 24, 2020

Thanks, JKPieterse , for your suggestion.

I could actually resolve the issue by using .Formula instead of .Value:

 cel.Formula = "=" & cel.Formula & "/USD_ConversionRate"