how to make my ThisWorkbook work with my code

[dmcgov]

i have this code that works in another spreadsheet. but when i run it on this workbook, it fails.

Please Login or Register  to view this content.

if fails on this line:

Please Login or Register  to view this content.

thoughts?

[xlnitwit]

Hi,

What is the error message? If it is a "Subscript out of range" error then it means that the workbook containing the code does not have a tab called "BigMaster".

[dmcgov]

weird, i just restored the code from the old worksheet and its working fine. must have been a typo or something.

but yes that was the error message.

thanks xlnitwit.