Is it possible to mix named ranges and FormulaArray (R1C1 formatting)?
I have a macro that enters a complex formula:
formula Selection.FormulaArray = _
"=IF(ISERROR(INDEX('Class Schedule'!C[-8]:C[-6],SMALL(IF('Class Schedule'" _
& "!C[-8]=RC8,ROW('Class Schedule'!C[-8])),ROW(R[-3]),3)),"""",INDEX('Class Schedule'" _
& "!C[-8]:C[-6],SMALL(IF('Class Schedule'!C[-8]=RC8,ROW('Class Schedule'!C[-8])),ROW(R[-3])),3))"
Instead of Row[-3], I need the underlined portions to reference the first row of the sheet. However, I can't use R1 because I need to fill this formula down and have the row value increment. But I can't figure out how to replace Row[-3] with a reference to myRow or something.
Any help would be appreciated.
Bookmarks