Macro to write formula in cell based on value in different cell

I want to create a macro that uses the values from cell A1 and A2 to write a formula in cell A3. It is important that the formula in A3 contains the actual numbers from A1 and A2. I don't want the forumula to just be "=A1+A2", but rather "=2.50+3.75" (if those are the values of A1 and A2 at the time of running the macro).

This macro works, but does not give me the decimals from A1 and A2 in the formula of A3. Tried to dim as single or double instead, but that only returns run time error 1004 Method 'Formula' of object 'Range' failed. Why?

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have done it for you this time. I've also moved the thread to the correct forum section.)

this worked for me ...

Please Login or Register  to view this content.

result in formula bar

=2.65+4.09

(6.74)

Thank you, both of you. Unfortunately I am still getting the same error message. I'm starting to think it is related to the use of "," as decimal separator?

Macro works when values in A1 and A2 are whole numbers, but not when they have decimals separated with commas.