| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Concatenate Multiple Cells
Hello everyone. I need your help. I using FOR LOOP to loop through N-number of times in order to find necessary data. I have trouble placing this data in ONE cell: Here is code that I use For i = 1 To intRowCount ActiveCell.FormulaR1C1 = "=R" & Range("F26").Value & "C3&""|"" " Range("F26").Value = Range("F26").Value + 1 ActiveCell.Value = ActiveCell.Value + ActiveCell.Value ' + ActiveCell.Offset(1, 0).Select Next i How to place programmatically found data into ONE cell Thanks in advance, Sonya -- Sonya795 ------------------------------------------------------------------------ Sonya795's Profile: http://www.excelforum.com/member.php...o&userid=26110 View this thread: http://www.excelforum.com/showthread...hreadid=397276 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add the same character(s) to multiple cells in a column (or row) . | Excel Discussion (Misc queries) | |||
| Concatenate cells in Pocket Excel | Excel Discussion (Misc queries) | |||
| Macro Help: Concatenate Populated Cells in Column A | Excel Discussion (Misc queries) | |||
| How do I insert a symbol BEFORE text for multiple cells in Excel? | Excel Worksheet Functions | |||
| how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
