| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about a formula
jln
Then [2] refers to F, 2 columns to the right of D (D27) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "jln via OfficeKB.com" <u25956@uwe wrote in message news:6afed105b6b42@uwe... Here is what it looks like when i record it Range("D27").Select ActiveCell.FormulaR1C1 = "=SUMIF(TOEPIEXP!C[2],1,TOEPIEXP!C[34])-R[-2]C-R [-1]C" Nick Hodge wrote: jln Using R1C1 notation, everything is relative to the range the formula is in. you have clipped the part before FormulaR1C1 If this was Range("C1").FormulaR1C1 then C[2] would refer to Column E Does that make sense? Nick that what i thought but im not using column 2 im using 6. I have recorded for about 20 lines all using column 6 and they all say 2. SO how [quoted text clipped - 15 lines] is the work sheet. What is C? what is 40? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200612/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie Formula Question - how to get formula to repeat in each subsequent row? | New Users to Excel | |||
| Formula Question... | New Users to Excel | |||
| Formula question | Excel Worksheet Functions | |||
| Another Formula Question | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Threaded Mode
