Here is my code. I would like to know since every file has a different
amount of records, if there is a way process my code only to the last
active record?
In this case here I put 6500 records but I really do have that many
records.
And my record must start with the second record for processing.


Range("V2").Select
ActiveCell.FormulaR1C1 = "=CONCATENATE(C[-2],"" "",C[-10],""
"",C[-16])"
Selection.AutoFill Destination:=Range("V2:V*6500*"),
Type:=xlFillDefault
Range("V2:V65000").Select
Selection.Copy
Range("F2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Columns("T:Z").Select
Selection.ClearContents


--
jcc31
------------------------------------------------------------------------
jcc31's Profile: http://www.excelforum.com/member.php...o&userid=24692
View this thread: http://www.excelforum.com/showthread...hreadid=490965