How do I modify current code to limit the number of rows/columns my table of contents do

Change all your Range references from, for example

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and use

Please Login or Register  to view this content.

in place of "B"

Then use code like

Please Login or Register  to view this content.

Sorry, that was poorly worded.

Once you have changed to TOC.Cells(NewRow, iCol), you need to initialize iCol so that the code will start populating in column B of TOC, so you need to add the line

iCol = 2

Somewhere in your code before you start using it to address cells within the TOC. So maybe right after the line

Const StartRow As Long = 5
iCol = 2

You can also, then, change

TOC.Cells(StartRow - 2, "B")

to

TOC.Cells(StartRow - 2, iCol)

Before you use a variable, you need to dimension it, since you are using "Option Explicit" at the top of your module. Honestly, given your code to this point, I'm surprised you weren't aware of that as a source of error.

Please Login or Register  to view this content.

Using the button for charts put an ugly doubled text look on a cell - to get around that, I used the selection change event of the workbook.

Put this into the codemodule of the ThisWorkbook object

Please Login or Register  to view this content.

And use this code.

Please Login or Register  to view this content.