| 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 | |||
Hybrid Mode
