Macro to copy array formula down column B from Cell B8 onwards

Hi Experts Using Excel 2013

How would you right a macro to copy the following array formula down column B8 onwards until row 300...worksheet "test1"

=IFERROR(INDEX('Unique List'!$B$2:$B$2000,SMALL(IF('Unique List'!$A$2:$A$2000=$B$3,ROW('Unique List'!$A$2:$A$2000)-ROW('Unique List'!$A$2)+1),ROWS(B$8:B8))),"")
route217Asked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Try this.....

Range("B8").AutoFill Destination:=Range("B8:B300"), Type:=xlFillDefault

Open in new window

0
 
route217Author Commented:
0
All Courses

From novice to tech pro — start learning today.