View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default Transpose a column list to every other cell in a row on anothersheet, then center

On Friday, August 14, 2015 at 3:58:18 AM UTC-7, Claus Busch wrote:
Hi Howard,

Am Fri, 14 Aug 2015 03:34:58 -0700 (PDT) schrieb L. Howard:

I added some lines to do additional stuff.

Do you see any glaring errors? It does exactly what I want it to do, but may not be best coding practices.


no, every thing is okay.

But delete [D6].Activate at the end of the code
It's not good practice and also superfluous.

If you want go back to D6 then try it with
Application.Goto range("D6")


Regards
Claus B.



Okay, and thanks again.

Howard