Copy Formula On Range leaves wheel spinning

Hello,

I am using the code below to copy formulas down a range of rows. The number of rows is small. It is the number of columns that is longer. The process works but the wheel spins for a while. I was wondering if there was another way to input the code so it is faster and less obvious to the user that when they click a button it is calculating for a bit.

This is an example of the formulas in the columns.

=IF(ISNA(INDEX('Cleaning Sub Catg Item Data'!$E:$E,MATCH($A4&H$3&$F$3,INDEX('Cleaning Sub Catg Item Data'!$A:$A&'Cleaning Sub Catg Item Data'!$D:$D&'Cleaning Sub Catg Item Data'!$C:$C,0),0))),"Input Image Record",INDEX('Cleaning Sub Catg Item Data'!$E:$E,MATCH($A4&H$3&$F$3,INDEX('Cleaning Sub Catg Item Data'!$A:$A&'Cleaning Sub Catg Item Data'!$D:$D&'Cleaning Sub Catg Item Data'!$C:$C,0),0)))

Please Login or Register  to view this content.

The file also calculates if I enter into any cell. It recalcs the whole file which takes a little bit. Like I said it works just not as efficient as I would expect.

Thanks. It is taking just as long with the code you suggested. Also it doesn't seem to slow it down anymore with the If(ISNA formula vs just the straight index without iferror or if(isna. I am assuming it is because there are so many columns that VBA is pulling down.