Good Morning,

Please can someone offer some advice.

I have the following line of VBA code


Range("F2:J2") = Application.Evaluate("VLOOKUP(E2, 'Sheet2'!$A$1:$K$1000,{2,3,4,8,7},FALSE)")


This code does what I require; getting values from Sheet 2 when a particular code is input to cell E2 on sheet 1 (and making text rather than formula in the cells in sheet 1). So when code in input in E2, then automatically values on F2, G2, H2, I2, J2 are populated with information from sheet 2.


But i'm not sure how to 'copy' this formula down to say "F3:J3", "F4:J4", etc all the way down to perhaps "F200:J200"


Can anyone help me. I hope my post makes sense to you.


Thanks for considering this post.