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