Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving multiple row cells into one row
Hello,
I am new to Excel formulas and just need to know how to move the contents of multiple rows into one row without needing to know (hard code) the end cell value. (this could be C1 or it could be EE1 or....) Example: ABC DEF GHI into ... ABC DEF GHI (contents of multiple rows into one row) Is there a simple formula syntax value for range for this type of thing in the options in menu bar for "text to columns"? Thank you. - S --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving multiple row cells into one row
Why don't you use PasteSpecial Transpose when you paste?
Or coding something like this. Code: -------------------- Sub Test() Dim Target As Range On Error Resume Next Set Target = Application.InputBox("Select Data", Type:=8) If Target Is Nothing Then Exit Sub Target.Copy Selection.PasteSpecial Transpose:=True Application.CutCopyMode = False End Sub -------------------- --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving text around cells without moving boarder lines | Excel Discussion (Misc queries) | |||
Enter Key + Dragging Cells / Moving Cells | Excel Discussion (Misc queries) | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
Moving data from multiple cells to one column | Excel Discussion (Misc queries) | |||
Moving cursor to identical cells across multiple sheets | Excel Discussion (Misc queries) |