Thread: Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list on same & another sheet
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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote