Displaying Worksheets Names

    Hi


    i have a problem with getting all my worksheet names in a column and to count the number of worksheets.


    Code
    Public Sub rangeref()
Dim iSheetCount As Integer


Range("c2").Select
iSheetCount = Worksheets.Count
End Sub


    i don't have a code yet for all the worksheets names in a column. i am not very sure how to go about doing that.


    Thank You

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login