Table of Contents

[Nigel Q]

Dear all

I have a workbook with 20+ worksheets. Is there any way of generating a
list of worksheets without having to physically type them out.

TIA

Nigel

 

[JE McGimpsey]

Take a look here:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[Frank Kabel]

Hi
have a look at
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[Nigel Q]

Thanks guys

Found the code - it works a treat.

Nigel

 

[Nigel Q]

Thanks guys, all sorted.

Nigel