subscript is out of range

[ulvrah]

The code below pastes clipboard and then stretches the pasted formula. But occasionally I get subscript is out of range error. Why is that?

I use this code for sheet called TOC

[rorya]

The only reason I could see for that would be if the active workbook at the time doesn't have a TOC worksheet.

[ulvrah]

In all workbooks that I have there is a TOC. I usually copy the clipboard from excel workbook that does not have a TOC sheet. I think, excel confuses workbooks??

The workflow for me is to open two workbooks at the same time and copy from one which does not contain TOC and drop to another one which contains TOC sheet

[rorya]

In all workbooks that I have there is a TOC. I usually copy the clipboard from excel workbook that does not have a TOC sheet.

Slight contradiction there. I stand by my original suggestion as I can't see anything else that would cause that error - unless it's actually being caused by other code.

[ulvrah]

Appreciate your opinion on this. I have one more code which is as follows:

[rorya]

If that's being used in a cell formula, it would not cause that error.

[ulvrah]

Strangely enough when I copy clipboard and click on TOC worksheet and then play the macros from Alt + F11 it works. But not otherwise