Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 76
  • Last Modified:

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))),"")
0
route217
Asked:
route217
1 Solution
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Try this.....

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

Open in new window

0
 
route217Author Commented:
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now