Search : in
By :

VBA code to write formulae in Excell

Last answer on Oct 8, 2009 8:02:21 am BST Pali, on Oct 8, 2009 5:53:32 am BST 
 Report this message to moderators

Hello Sir

I have values (Digits) in excell columns like A & B , i need to display the sum of each digits (A+B) in column C.
i dont want to display the formula in column c. could anyone help me in dis .

Configuration: Windows XP Internet Explorer 6.0

Best answers for « VBA code to write formulae in Excell » in :
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Download Codejay - Code Generator ShowCodejay - Code Generator allows you to administer the database of a website. It also allows to create reports for the website and produce several types of source codes: ASP, ASP.NET, COLDFUSION and PHP without writing a single line of code. Codejay...
Download K-Lite Codec Pack Full ShowK-Lite Codec Pack is a collection of VFW/ACM codecs, DirectShow filters and tools. Codecs and DirectShow filters are needed for encoding and decoding (playing) audio and video formats. Contents of version 4.7.0 : Player: Media Player...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
ASCII Code ShowData coding Morse code was the first code used for long-distance communication. Samuel F.B. Morse invented it in 1844. This code is made up of dots and dashes (a sort of binary code). It was used to carry out communication much faster than could...
Video compression (codecs) ShowThe concept of codec A non-compressed video image occupies approximately 1 MB. In order to obtain a fluid video, it is necessary to have a frequency of at least 25 or 30 images per second, which produces a data flow of approximately 30 MB/s, that...

1

 iveal, on Oct 8, 2009 8:02:21 am BST

Dear Sir,

The following is the formula that you must use:

= A1+B1

Thanks.

Reply to iveal