I just helped a fellow here at the forum with some code for picture import. My code don't look too bad and it works but it's slower than the code of threadstarter. Why? His code isn't exactly by the book (sorry encleadus, no harm meant ), looping through UsedRange several times. Yet my code seems to run quite a bit slower. It differs at least 1 second. What am I missing here? I'm testing on a folder containing 4 jpg's, same for both.
http://www.excelforum.com/excel-prog...ith-macro.html