Previous Topic Next Topic

Creating Table of Contents in Excel

Closed
Sam - Sep 10, 2008 at 08:07 AM
inteloutside Posts 20 Registration date Tuesday August 19, 2008 Status Member Last seen March 26, 2009 - Sep 10, 2008 at 03:22 PM
Hello,

I have been trying to create a table of contents in Excel, by using a macro. It doesn't work, then I tried using a non VBA on the first sheet, but it keeps giving me the error #Name?. Could some one give me a code to creat a Table of Contents on the first sheet that will update as I add or delete sheets.

Thanks

Sam
Related:

1 response

Answer 1 / 1
inteloutside Posts 20 Registration date Tuesday August 19, 2008 Status Member Last seen March 26, 2009 9
Sep 10, 2008 at 03:22 PM
have you tried the help for macros on the forum here?

just try it you might find it very helpful and also what does the help in excel tells you?
1

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response