Creating index sheet with link to active cells

C

Chad Somerset

Ok. I have this script for pulling in sheet names. Now,
how can I modify this to also pull in specific active
cells from each of the sheets?

Public Sub IndexSheets()

Dim i As Integer

For i = 1 To Sheets.Count
ActiveCell.Offset(i+1, 0).Value = Sheets(i).Name
Next i

End Sub

I've played around with it, but I confess I am not a VB
programmer and I haven't had much success.

Thanks.
 
Top