Vlookup-Multiple values returned-insert new row

[0Das0]

Hi All,

I've been trying to get a macro to work where I can use VBA to do a lookup which will return multiple values. Then when these have been found insert a new row and paste vertically the values returned. I know how to write a lookup in VBA

Application.WorksheetFunction.VLookup("A1",Sheet2."A1:B8",2, False)

and also how to insert a new row. I'm just struggling to get it to all flow together.


Steps

1) Do Vlookup
2) Return multiple values
3) Insert new rows
4) Paste multiple values

Thanks in advance!