Displaying Worksheets Names

  • Hi

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

    Public Sub rangeref()
    Dim iSheetCount As Integer
    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!