Solved: Tab sheet Name In the Sell

[sameer.sh]

Hi All,

Plz I'm looking to find Macro it can copy the name of all tab sheet as (sheet1, sheet2, sheet3 ... ) and pot it in the different sell in one sheet as

sheet1
sheet2
sheet3

Plz ASAP,

thanks

[mdmackillop]

[VBA]Dim i As Long

For i = 1 To Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next
[/VBA]

[sameer.sh]

Could you please attached excel file explain it,

And thanks for required,

[mdmackillop]

Check the VBA Help files for basic information on Sub routines and Functions.

[sameer.sh]

thanks for route ....

[sameer.sh]

Please Mr.mdmackillop if you have a solution for this issues Please sent it to me because from morning I'm read to solve it but it's useless and I'm new in VBA Program,

and on the attached file you can see what i mean exactly .

[mdmackillop]

See attached

[sameer.sh]

Thank You Very Very Much ...........