Hi all ,

can you any one answer my question , i have pasted my macro and in bracket i have given what changes i need .

1.(in Macro it showing 2to3 but i want to select row ,in how many row values are there it may be 5 or it may be 8
2.want to copy available row(not "A2:A170"
3.want to copy available row(not "A2:C170"

For v = 2 To 3 (in Macro it showing 2to3 but i want to select row ,in how many row values are there it may be 5 or it may be 8 )
Sheets("TCCP").Select
Cells(v, 1).Select
Application.CutCopyMode = False
Selection.Copy