| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transpose rows to column (cell) | Excel Discussion (Misc queries) | |||
| How to transpose and concatenate long list in one column? | Excel Worksheet Functions | |||
| Move to specific sheet and cell based on criteria entered on anothersheet | Excel Programming | |||
| check text in cell for at least one keyword from a list on anothersheet | Excel Worksheet Functions | |||
| find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
Threaded Mode
