| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining Cell into One
Is there an easy way to combine say A1 to A5000 to B1 seaparated by comma ?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combining Cell into One
Sub combine()
Dim text as string, i As Long For i = 1 To 5000 text = text & Cells(1, 1) Next [b1] = text End Sub PAtrick Molloy Microsoft Excel MVP -----Original Message----- Is there an easy way to combine say A1 to A5000 to B1 seaparated by comma ? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining a whole number and a % in one cell | Excel Discussion (Misc queries) | |||
| Combining Cell Content | Excel Discussion (Misc queries) | |||
| Combining Cell Contents | Excel Worksheet Functions | |||
| Combining multiple cell information into one cell | Excel Discussion (Misc queries) | |||
| Cell Combining Question | Excel Worksheet Functions | |||
Linear Mode
