Select a range of sheets.

[Jeffro2p]

Please Login or Register  to view this content.

Hi,
I am using the following code to create a table of contents but I don't want to use every sheet in the book. The ones at the back section are for data storage only.

I also don't want to include the first data input page.

Please Login or Register  to view this content.

Thanks

[Jeffro2p]

It also seems to set Index page as 2 pages when there is only 1, not sure why.

[FDibbins]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I will add them for you - this time

[Jeffro2p]

Thank you.

[Jeffro2p]

Can anyone help with this?

[Jeffro2p]