Subscript out of range error

[spursrule68]

Can someone identify what is causing this problem?

Please Login or Register  to view this content.

edit: its something to do the Range("Headline").Value = aTD(3) line. Don't know what though.

[spursrule68]

question updated.

[spursrule68]

please guys, this is urgent.

I suspect its a fairly simple fix

[mikerickson]

if sTD is "cat, dog", Split will return a two element array and there will be no aTD(3).

A quick and dirty fix would be to change this line so there is alwayas an aTD(3)

Please Login or Register  to view this content.