[AccessD] (OT) Excel - adding cell values

:((
Jim, unfortunately this doesn't seem to work either. Gives some weird numbers


Workbooks.Open Filename:="L:\PCO\Artemis\associates.xls"
    A = Range("C11").Value
    B = Range("C12").Value
    C = Range("C13").Value + Range("C14").Value + Range("C15").Value

For i = 16 To 21
  E = E + Range("E" & CStr(i)).Value
 Next i

 For i = 22 To 33
  E = E + Range("E" & CStr(i)).Value
 Next i

For i = 34 To 94
  F = F + Range("F" & CStr(i)).Value
 Next i

>
> If you're trying to sum this range in VBA code the SUM function is not a
> part of that library.  You have two options that I see - one is loop
> through the range reassigning the value of C:
>
> <snip>
>  For i = 13 to 18
>   C = C + Range("C" & CStr(i))
>  Next i
> </snip>
>
> or assign "=SUM("C13:C18")" to a cell's Formula property.
>
> HTH,
>
> Jim DeMarco
> Director of Product Development
> HealthSource/Hudson Health Plan
>
>
> -----Original Message-----
> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
> Sent: Tuesday, May 27, 2003 12:31 PM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] (OT) Excel - adding cell values
>
>
> It was a first thing i tried. Gives me an error message "sub or function
> not defined"
>
>
>> You can try C = SUM("C13:C18")
>>
>> Doris Manning
>> Database Administrator
>> Hargrove Inc.
>> www.hargroveinc.com
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>> Oleg_123 at xuppa.com
>> Sent: Tuesday, May 27, 2003 10:12 AM
>> To: accessd at databaseadvisors.com
>> Subject: [AccessD] (OT) Excel - adding cell values
>>
>>
>> He group,
>> does anyone know if I can use SUM in the case below ? I can't seem to
>> find it. Thanks
>>
>> C = Range("C13").Value + Range("C14").Value + Range("C15").Value +
>> Range("C16").Value + Range("C17").Value + Range("C18").Value
>>
>>
>> -----------------------------------------
>> You are entitled to Get 100% FREE perfume (S&H is FREE)!
>> Click Here: http://azjmp.com/az/ch.php?f=176&i=657&sub=webmail
>>
>>
>> _______________________________________________
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> _______________________________________________
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
>
>
> -----------------------------------------
> You are entitled to Get 100% FREE perfume (S&H is FREE)!
> Click Here: http://azjmp.com/az/ch.php?f=176&i=657&sub=webmail
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> ***********************************************************************************
> "This electronic message is intended to be for the use only of the named
> recipient, and may contain information from Hudson Health Plan (HHP)
> that is confidential or privileged.  If you are not the intended
> recipient, you are hereby notified that any disclosure, copying,
> distribution or use of the contents of this message is strictly
> prohibited.  If you have received this message in error or are not the
> named recipient, please notify us immediately, either by contacting the
> sender at the electronic mail address noted above or calling HHP at
> (914) 631-1611. If you are not the intended recipient, please do not
> forward this email to anyone, and delete and destroy all copies of this
> message.  Thank You".
> ***********************************************************************************
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
You are entitled to Get 100% FREE perfume (S&H is FREE)!
Click Here: http://azjmp.com/az/ch.php?f=176&i=657&sub=webmail