sateesh kumar
Board Regular
- Joined
- Dec 5, 2013
- Messages
- 63
Hi to all
Am creating Test case template, in that i want to count no Test cases, no of passed, fail...etc. those are counted in with in sheet in D to G columns only. but i when ever i want check the test case results, its taking more time ,i have 25 sheets. if new sheet will generate , what i want is,that sheet names and sheet result also reflect the in sheet 1.
Actully am done the Display the Sheet names with Macro. but when ever run the code sheet names will inserting next columns,not over writing in that columns only. i want insert data particular column only.
here is my code
Thanks for Advance
Am creating Test case template, in that i want to count no Test cases, no of passed, fail...etc. those are counted in with in sheet in D to G columns only. but i when ever i want check the test case results, its taking more time ,i have 25 sheets. if new sheet will generate , what i want is,that sheet names and sheet result also reflect the in sheet 1.
Actully am done the Display the Sheet names with Macro. but when ever run the code sheet names will inserting next columns,not over writing in that columns only. i want insert data particular column only.
here is my code
Code:
Sub SheetNames()
Columns(1).Insert
For i = 1 To Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next i
End Sub
Thanks for Advance
Last edited: