|
|
#2
12-08-2011, 11:31 AM
|
|||
|
|||
look at this line:
ActiveCell.FormulaR1C1 = "=IF(SUMIF($Q$8:$Q$469,Q8,$P$8:$P$469) = 0, """", SUMIF($Q$8:$Q$469,Q8,$P$8:$P$469) )" on the left side, reference style is R1C1, on the right side is another reference style R1C1 reference style looks like this: ActiveCell.FormulaR1C1 = "=R[-3]C[-1]-R[6]C[-1]" you should use: ActiveCell.Formula ="your formula" to match the formula reference style 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Compile error: sub or function not defined.. | xena2305 | Excel Programming | 0 | 08-02-2011 10:17 AM |
 User Defined Default Settings in Insert
|
J_oe | Word | 1 | 02-17-2011 10:55 AM |
|
Change fonts of a defined word with VBA
|
Michael007 | Word | 6 | 02-01-2011 04:52 PM |
| TOC printing Error Bookmark not Defined | techexpressinc | Word | 0 | 12-14-2008 05:24 PM |
|
Defined Views in Tasks
|
Inga | Office | 3 | 07-20-2005 07:10 AM |
Windows Vista 
Office 2010 32bit
Threaded Mode