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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03:26 PM.