Venkatesh Palani's blog
TCCP Macro
Submitted by Venkatesh Palani on 8 January, 2013 - 10:47Hi 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
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago