|
|
#2
08-25-2014, 10:24 PM
|
|||
|
|||
If you are putting a sum into a cell then I think all that's missing is your equals sign.
Code:
ActiveSheet.Range("$A$" & i).Value = "=$R$42" & "-140.5"
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
 Keep cell in formula constant
|
jprt68 | Excel | 1 | 06-26-2012 08:31 AM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
| How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Windows 7 64bit 
Office 2003
Threaded Mode