Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incorrect formula outcome
' , insted of ;
Selection.Formula = "=ROUND(" & tgr & ",0)" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incorrect formula outcome
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incorrect formula outcome
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incorrect formula outcome
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incorrect formula outcome
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! -- leonidas ------------------------------------------------------------------------ leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375 View this thread: http://www.excelforum.com/showthread...hreadid=565528 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for formatting rows and columns minimizing the outcome. | Excel Discussion (Misc queries) | |||
how do i get a cell to fill red/blue as the outcome of a formula? | Excel Worksheet Functions | |||
creating outcome series from formula | Excel Worksheet Functions | |||
format the outcome of a formula | Excel Discussion (Misc queries) | |||
Stop % showing in outcome of formula | Excel Worksheet Functions |