Hi All...........

I have a macro that works fine, except it takes too long to
run......something like a couple of minutes. The thing that makes it slow
is the following line.........

Worksheets("BladesX1").Range("FieldBladesX1").Form ula =
"=IF(ISNA(VLOOKUP(($C8&""_""&D$1&""_""&D$4),Master Namefile!$B:$S,14,FALSE)),
"""",VLOOKUP(($C8&""_""&D$1&""_""&D$4),MasterNamef ile!$B:$S,14,FALSE))"

It's all one line, the word-wrap is playing it here.........
The MasterNamefile sheet is a database of some 15,000 lines. The
FieldBladesX1 contains some 1000+ cells. I know it's doing a lot of work,
and it does exactly as it's supposed to, but is there any way to speed it up
any?

TIA
Vaya con Dios,
Chuck, CABGx3