Extract Worksheet Title/Refence

  • Thread starter Thread starter Ludim
  • Start date Start date
L

Ludim

I have a huge list of worksheets, I need to check that I have captured them
all against our product list. Is there a way to extract every worksheet to
make a list and compare?
 
Hi,

So you have 1 workbook with a huge number of sheets and you want to workshet
titles and references? What does worksheet references mean?

To extract the name of all the sheets in a workbook to a column A in sheet1
use a macro

Sub mySheets()
I=1
For each sh in Worksheets
Range("A1").Offset(I,0) = sh.Name
I=I+1
Next sh
End Sub

(untested)
 
Back
Top