Hi

This code works well when placed in cell C5 of worksheet PrintRpts.

=INDEX(MasterList!F:F,MATCH(A8,MasterList!A:A,0))

But, I need to do the same thing by VB, and my syntax needs fixing:

Worksheets("PrintRpts").Range("C5") =
INDEX(MasterList!F:F,MATCH(A8,MasterList!A:A,0))


suggestions appreciated
anny