Subscript out of Range error

[mastercl90]

Any expert here know about this error?? my excel vba code can be run n work but sometime will gv me "Subscript out of Range error" error....any1 knoe y will cause this happend?? sometimes for some excel WB sheet can be run......for some WB it gv me this error.....strange....= =''

[Trebor76]

Hi there,

That error is usually a result of a tab being referred to that doesn't exist in the workbook.

For example, this line of code will produce that error if there's no Sheet5 in the active workbook:

Please Login or Register  to view this content.

HTH

Robert

[alansidman]

Suggest you upload a copy of your workbook along with your VBA code. I also suggest you not use Texting language in your posts as it may be confusing to many users and is not an appropriate means of communication in forums.

[Marc L]

Not strange, just a bad code …

[mastercl90]

Hi there,

That error is usually a result of a tab being referred to that doesn't exist in the workbook.

For example, this line of code will produce that error if there's no Sheet5 in the active workbook:

Please Login or Register  to view this content.

HTH

Robert

ya u r correct...and i solve it already....thk a lot for reply~~thank~~

[Trebor76]

You're welcome