Not clear on what you are doing.

The first formula creates a formula such as =$C$7&"|"

You then try to add that to itself, which doesn't work as it has text. Do
you mean?

ActiveCell.Value = ActiveCell.Value & ActiveCell.Value


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sonya795" <Sonya795.1u0tuc_1124471114.639@excelforum-nospam.com> wrote in
message news:Sonya795.1u0tuc_1124471114.639@excelforum-nospam.com...
>
> 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
>