View Single Post
 
Old 11-23-2015, 03:45 AM
jap7675 jap7675 is offline Windows 8 Office 2007
Novice
 
Join Date: Nov 2015
Posts: 6
jap7675 is on a distinguished road
Default Dymanic Range Starting at a Cell Defined by a Count

Hello,

Im trying to run a dynamic range starting at a cell defined by another cell.
The first part of my dynamic range works, ending at a cell defined by another cell.

If CheckBox1.Value = True And CheckBox2.Value = True Then

With Sheets("Summary").Range("E22")
.FormulaArray = "=IFERROR(INDEX('1600 Daily'!G$3:G$300, SMALL(IF('1600 Daily'!$F$2:$F$300=1, ROW('1600 Daily'!$F$2:$F$300)-2),ROWS(G$2:G2))),"""")"
.AutoFill Destination:=Range("E22", Cells(Range("M4"), "E")), Type:=xlFillDefault
End With

End If

I just need this formula performed across the range of cells.
It seems to be this small section that doesnt work 'Range(Cells(Range("M4"), "E")))'

Thanks in advance for any help anyone can provide!
Reply With Quote