Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to alist on same & another sheet
On Saturday, September 28, 2013 4:22:12 AM UTC-7, Claus Busch wrote:
Hi Howard,
Am Sat, 28 Sep 2013 04:14:09 -0700 (PDT) schrieb Howard:
One problem with the last code, it misses I entry of all the ones I've tried.
the last two lines are only if you want to transpose the array. If you
don't want, delete these lines. If you want to transpose, delete the two
lines in front.
But don't run both.
Regards
Claus B.
I left the last two lines commented out. What I see is that it seems to over write the previous posting. The xlUp offset used in the earlier code worsk like I want it to, but coming from the top down to make the list makes more sense to me.
Howard
|