<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2652.35">
<TITLE>RE: [AccessD] (OT) Excel Range Question</TITLE>
</HEAD>
<BODY>
<P><B><I><FONT SIZE=2>---- London Borough of Bromley E-Mail Disclaimer ----</FONT></I></B><I></I>
<BR><FONT SIZE=2>"For information about Bromley Council visit our web site www.bromley.gov.uk"</FONT>
</P>
<P><FONT SIZE=2>"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." </FONT></P>
<P><B><I><FONT SIZE=2>---- End of Disclaimer ---- </FONT></I></B>
</P>
<P><FONT SIZE=2>Oleg,</FONT>
</P>
<P><FONT SIZE=2>I think something along these lines will work, obviously change the cell reference and the range.</FONT>
</P>
<P><FONT SIZE=2>With ActiveCell</FONT>
<BR><FONT SIZE=2>.Formula = "=sum(a1:a3)"</FONT>
<BR><FONT SIZE=2>End With</FONT>
</P>
<P><FONT SIZE=2>HTH</FONT>
<BR><FONT SIZE=2>RyanS</FONT>
</P>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Oleg_123@xuppa.com [<A HREF="mailto:Oleg_123@xuppa.com">mailto:Oleg_123@xuppa.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: 22 May 2003 20:21</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: [AccessD] (OT) Excel Range Question</FONT>
</P>
<BR>
<P><FONT SIZE=2>---- London Borough of Bromley Security Notice ---- </FONT>
<BR><FONT SIZE=2>"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."</FONT></P>
<P><FONT SIZE=2>---- End of Notice ----</FONT>
</P>
<P><FONT SIZE=2>hey group, Is there a shorter way to calcute sum of cells as opposed to</FONT>
<BR><FONT SIZE=2>what I've done below ? like C = Sum("C12:C15").value ?</FONT>
</P>
<BR>
<P><FONT SIZE=2>C = Range("C13").Value + Range("C14").Value + Range("C15").Value</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-----------------------------------------</FONT>
<BR><FONT SIZE=2>You are entitled to Get 100% FREE perfume (S&H is FREE)!</FONT>
<BR><FONT SIZE=2>Click Here: <A HREF="http://azjmp.com/az/ch.php?f=176&i=657&sub=webmail" TARGET="_blank">http://azjmp.com/az/ch.php?f=176&i=657&sub=webmail</A></FONT>
</P>
<BR>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>