PDA

View Full Version : Solved: Tab sheet Name In the Sell



sameer.sh
01-18-2012, 04:06 PM
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
01-18-2012, 04:57 PM
Dim i As Long

For i = 1 To Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next

sameer.sh
01-19-2012, 01:49 AM
Could you please attached excel file explain it,

And thanks for required,

mdmackillop
01-19-2012, 05:07 AM
Check the VBA Help files for basic information on Sub routines and Functions.

sameer.sh
01-19-2012, 05:47 AM
thanks for route ....

sameer.sh
01-20-2012, 11:29 AM
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
01-20-2012, 12:48 PM
See attached

sameer.sh
01-20-2012, 01:16 PM
Thank You Very Very Much ...........