| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy row info but not in normal column sequence
On Wednesday, June 12, 2013 10:47:10 PM UTC-7, Claus Busch wrote:
Hi Howard, Am Wed, 12 Jun 2013 12:14:33 -0700 (PDT) schrieb Howard: Exactly what I needed. a liitle step to optimize the code: You can refer directly instead of copy and paste: For i = LBound(myArr) To UBound(myArr) Sheets("Sheet2").Cells(LRow, i + 3) = _ .Cells(rngC.Row, myArr(i)) Next i Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 I'll plug that in and give it a try. Thanks again. Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy info into blank cells within a column (going up the co | Excel Discussion (Misc queries) | |||
| Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
| How to update column info based on column info from another worksh | Excel Discussion (Misc queries) | |||
| comparing a column of cell and then copy info | Excel Programming | |||
| comparing a column of cell and then copy info to other cells | Excel Discussion (Misc queries) | |||
Threaded Mode
