Generate a list of sheet names:
In the excel we can see number of excel sheets in the bottom left corner.Minimum three sheets are in visible and we can also add number of sheets as our wish.Generally we use to name each work sheet one by one.if huge number of sheets are present then it becomes a little problem.
The solution for this is here:
Here is Excel Macro code for the above problem.
Sub test()
Dim x As Integer
For x = 1 To Worksheets.Count
Cells(x, 1).Value = Worksheets(x).Name
Next x
End Sub
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon