It would probably be much more efficient if the data layout permits to use AutoFilter in the code instead of Looping. This would apply to any Excel version