Incorrect formula outcome

Hi,

I have a piece of code (see below), but I get errors all the time. When the activecell is A1 with the value 4,25 the outcome in cell A3 should be the formula =ROUND(A1;0) and the value 4.
Can someone help me with this code? Thanks in advance!

Please Login or Register  to view this content.

' , insted of ;

Selection.Formula = "=ROUND(" & tgr & ",0)"

Hi,

the solution , instead of ; doesn't work.
Is there some other solution? Thanks in advance!

works fine here, what error do u get ?


"leonidas" skrev:

>
> Hi,
>
> the solution , instead of ; doesn't work.
> Is there some other solution? Thanks in advance!
>
>
> --
> leonidas
> ------------------------------------------------------------------------
> leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375
> View this thread: http://www.excelforum.com/showthread...hreadid=565528
>
>

Leonida I checked the proposed solution and it works. Psakse ki allo...

"leonidas" wrote:

>
> Hi,
>
> the solution , instead of ; doesn't work.
> Is there some other solution? Thanks in advance!
>
>
> --
> leonidas
> ------------------------------------------------------------------------
> leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375
> View this thread: http://www.excelforum.com/showthread...hreadid=565528
>
>

Hi,

Sorry, my mistake!
The , instead of ; does work fine. I had allready been changing the code to try to find a solution and made "selection.formula" into "selection.formulaR1C1" and then it doesn't work.
Thanks for you help!