| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange error
Dear All,
ActiveSheet.Cells(iloop, 5).Value = "=Sum(F688:F727)*0,05" This line triggers error 1004 Application defined or object difined error \/ ActiveSheet.Cells(iloop, 5).Value = "Sum(F688:F727)*0,05" If i ommit the = before Sum there is no error but the formular is not correct!! How do i solve this Filip |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Strange error
try
ActiveSheet.Cells(iloop, 5).Value = "=Sum(F688:F727)*0,05" ActiveSheet.Cells(iloop, 5)= application.Sum(range("F688:F727"))*1 or ActiveSheet.Cells(iloop, 5).Value = application.Sum(range("F688:F727"))*1 -- Don Guillett SalesAid Software "Filips Benoit" wrote in message ... Dear All, ActiveSheet.Cells(iloop, 5).Value = "=Sum(F688:F727)*0,05" This line triggers error 1004 Application defined or object difined error \/ ActiveSheet.Cells(iloop, 5).Value = "Sum(F688:F727)*0,05" If i ommit the = before Sum there is no error but the formular is not correct!! How do i solve this Filip |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Strange error
I get the same error. Could it be that your regional settings are no correct? I notices that you use 0,05 which will not work on my PC. I I change your code to use 0.05, it works for me. Go to Tools menu and select options. Check the International tab an make sure decimal separator is set to comma (assuming that's what yo use where you live). -- kkkni ----------------------------------------------------------------------- kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754 View this thread: http://www.excelforum.com/showthread.php?threadid=27084 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Strange error
ActiveSheet.Cells(iloop, 5).Formula = "=Sum(F688:F727)*0.05"
Change the comma to a period. Value would still work, but it is clearer to use Formula -- Regards, Tom Ogilvy "Filips Benoit" wrote in message ... Dear All, ActiveSheet.Cells(iloop, 5).Value = "=Sum(F688:F727)*0,05" This line triggers error 1004 Application defined or object difined error \/ ActiveSheet.Cells(iloop, 5).Value = "Sum(F688:F727)*0,05" If i ommit the = before Sum there is no error but the formular is not correct!! How do i solve this Filip |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Strange error
There is no need to change the decimal separator setting. Formula (or in
this case Value) expects US English formatting in VBA. -- Regards, Tom Ogilvy "kkknie" wrote in message ... I get the same error. Could it be that your regional settings are not correct? I notices that you use 0,05 which will not work on my PC. If I change your code to use 0.05, it works for me. Go to Tools menu and select options. Check the International tab and make sure decimal separator is set to comma (assuming that's what you use where you live). K -- kkknie ------------------------------------------------------------------------ kkknie's Profile: http://www.excelforum.com/member.php...fo&userid=7543 View this thread: http://www.excelforum.com/showthread...hreadid=270849 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Strange error
Wow. That's not very "internationally correct". :) -- kkkni ----------------------------------------------------------------------- kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754 View this thread: http://www.excelforum.com/showthread.php?threadid=27084 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Strange error
formulaLocal
will work with a localized formula. Where's the problem? -- Regards, Tom Ogilvy "kkknie" wrote in message ... Wow. That's not very "internationally correct". :) K -- kkknie ------------------------------------------------------------------------ kkknie's Profile: http://www.excelforum.com/member.php...fo&userid=7543 View this thread: http://www.excelforum.com/showthread...hreadid=270849 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Strange error
Changing the comma to a period did the job.
Thanks "Tom Ogilvy" wrote in message ... ActiveSheet.Cells(iloop, 5).Formula = "=Sum(F688:F727)*0.05" Change the comma to a period. Value would still work, but it is clearer to use Formula -- Regards, Tom Ogilvy "Filips Benoit" wrote in message ... Dear All, ActiveSheet.Cells(iloop, 5).Value = "=Sum(F688:F727)*0,05" This line triggers error 1004 Application defined or object difined error \/ ActiveSheet.Cells(iloop, 5).Value = "Sum(F688:F727)*0,05" If i ommit the = before Sum there is no error but the formular is not correct!! How do i solve this Filip |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| strange error | Excel Discussion (Misc queries) | |||
| strange error | Excel Worksheet Functions | |||
| Strange error | Setting up and Configuration of Excel | |||
| Very strange error | Excel Discussion (Misc queries) | |||
| Strange Error Message | Excel Discussion (Misc queries) | |||
Linear Mode
