On Wednesday, April 22, 2015 at 10:20:30 AM UTC-7, GS wrote:
You *might* see some speed improvement if you load the values into an
output array that gets 'dumped' into Sheet4 in one shot. This, of
course, depends how much data you're working with.

Only other thing I see (has nothing to do with speed!) is that you
specify the start index for your loop as 1 instead of using
LBound(varData), which begs me to ask "why?"!

--
Garry


The code is a modified version of one Claus wrote for a previous issue.

From my skill level it never occurred to me to question that.

Howard