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" wrote in
message ...
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