Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CopyTransposePaste into next blank row
Sub CopyTransposePaste()
Range("A1:A8").Copy Sheets(2).Range("A1").PasteSpecial Transpose:=True End Sub How can I amend this code so that data is copied into the next blank row in Sheet2? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) | Excel Discussion (Misc queries) | |||
Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions |