[AccessD] (OT) Excel Range Question

Smethurst, Ryan ryan.smethurst at bromley.gov.uk
Fri May 23 04:19:14 CDT 2003


---- London Borough of Bromley E-Mail Disclaimer ---- 
"For information about Bromley Council visit our web site
www.bromley.gov.uk" 

"The information contained in this message (including any attachments) is
confidential in that it is intended solely for the use of the recipient to
which it is addressed. If you are not the intended recipient, the use of the
information by disclosure, copying or distribution is prohibited and may be
unlawful." 
---- End of Disclaimer ---- 

Oleg,

I think something along these lines will work, obviously change the cell
reference and the range.

With ActiveCell
.Formula = "=sum(a1:a3)"
End With

HTH
RyanS


-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
Sent: 22 May 2003 20:21
To: accessd at databaseadvisors.com
Subject: [AccessD] (OT) Excel Range Question


---- London Borough of Bromley Security Notice ---- 
"Please treat all e-mail with caution. Only open attachments from trusted
business sources whose material you are sure is safe. Refer to the Council's
e-mail and internet users Code of Conduct for further guidance on the
correct use of the e-mail system."
---- End of Notice ----

hey group, Is there a shorter way to calcute sum of cells as opposed to
what I've done below ? like C = Sum("C12:C15").value ?


C = Range("C13").Value + Range("C14").Value + Range("C15").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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030523/d6dbc471/attachment-0001.html>


More information about the AccessD mailing list