Reply to thread

Message: [QUOTE="Walter Briscoe, post: 7421312"] In message <kutcpc$i93$1@dont-email.me> of Mon, 19 Aug 2013 08:14:51 in stations is a reference to a worksheet in a closed workbook. Stations refers to =[stations.xls]Sheet1!$A$1:$CB$427. I can't remember how [stations.xls] references C:\Users\IBM\AppData\Roaming\Microsoft\Excel\stations.xls If I open that workbook, my 13:25 becomes ~0:10 How do you measure 0.04 seconds? I am using my wrist watch. The COUNTIF was done to count the number of cells in which no VLOOKUP call is actually made. [/QUOTE]