Dymanic Range Starting at a Cell Defined by a Count

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Dymanic Range Starting at a Cell Defined by a Count

FAQ

Thread Tools

Display Modes

11-23-2015, 07:15 AM

Debaser

Windows 7 64bit Dymanic Range Starting at a Cell Defined by a Count

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

Then:

Code:

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").Value, "E")), Type:=xlFillDefault
End With

should work.

Tags

array, autofill, dynamic range

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count how many have completed each Training Course within a Date Range	dmcmillion	Excel	3	10-20-2014 09:59 AM
Worksheet defined cell sums	flextera	Excel	3	06-17-2014 11:12 AM
Data validation list filter with range defined by OFFSET	Mango123	Excel	4	03-18-2014 02:52 PM
Range.Information(wdStartOfRangeRowNumber): Application-defined or Object-defined err	tinfanide	Excel Programming	2	06-09-2012 10:19 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:13 AM.