![Command and conquer generals torrent download](https://knopkazmeya.com/25.png)
![visual basic for excel using r1c1 visual basic for excel using r1c1](https://www.superexcelvba.com/static/images/en/tutorial/vba-drag-manual.gif)
Turn on the macro recorder (Developer tab > Record Macro).
#Visual basic for excel using r1c1 code
Here are the steps to creating the formula property code with the macro recorder. Fortunately we can use the macro recorder to create the code for us. When your formulas are more complex or contain special characters, they can be more challenging to write in VBA. The Formula property can also be used to read an existing formula in a cell. 'Formula is a string of text wrapped in quotation marks 'Starts with an = sign Here is a simple example of a formula in a macro.
![visual basic for excel using r1c1 visual basic for excel using r1c1](https://brain.cc.kogakuin.ac.jp/~kanamaru/lecture/vba2003/2007_01/01-37.png)
The formula string must start with an equal sign = after the first quotation mark.
![visual basic for excel using r1c1 visual basic for excel using r1c1](https://upload-images.jianshu.io/upload_images/13529643-7e0309350d351236.png)
The value of the formula must start and end in quotation marks.
![Command and conquer generals torrent download](https://knopkazmeya.com/25.png)