| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Xpose twenty rows then the next twent etc.
Want to xpose a list of items in A to cells in B twenty at a time then the next twentyin B below the first etc. Thanks, Howard Option Explicit Sub SuperJoin() Range("B1") = Join(Application.Transpose(Range(Range("A1"), _ Range("A" & Rows.Count).End(xlUp))), " , ") '" / ") End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 120= rupees one hundred twenty only | Excel Worksheet Functions | |||
| Patek Philippe Twenty~4 Watch, Best Wristwatch | Excel Discussion (Misc queries) | |||
| creating a table from twenty worksheets | Excel Programming | |||
| how do i convert numbers (25) into words (Twenty Five Only) ... | Excel Worksheet Functions | |||
| How do I convert number 123 to text One Hundred and Twenty Three? | Excel Discussion (Misc queries) | |||
Threaded Mode
