Bill, you might try using DIRPlus() instead. It's much more flexible. Personally, I haven't used DIR for ANYTHING since I started using dirplus. You can find it in the UDF Forum.