Creating Table of Contents in Excel [Closed]

Report
-
inteloutside
Posts
20
Registration date
Tuesday August 19, 2008
Status
Member
Last seen
March 26, 2009
-
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

1 reply

Posts
20
Registration date
Tuesday August 19, 2008
Status
Member
Last seen
March 26, 2009
9
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3989 users have said thank you to us this month