runtime error 9 subscript out of range

Hello Forumers!

I would like to ask your help as I am struggling with this case for days and I cannot figure out what can cause this "runtime error 9 subscript out of range error". I would give some detail before the code.

There are two files "A.xlsm" and "B.xls". File "A" is open (this is where I would like to run my macro from on file "B") and "B" should be opened and a specific worksheet called "data" should be activated and copied every data from that sheet row by row to file "A" if a colum value is a special word. In file "A" at the start I create a sheet with the current date which is important for me to stay this way. This sheet is totally empty.

The code:

Please Login or Register  to view this content.

If there would be any guesses , hints or advice I would really appreciate it! I hope my description can be used to guide you to my problem.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi ted...

i guess you are facing errors at activate section..
just few suggestion..

instead of using Window object try to use Workbook object..

Please Login or Register  to view this content.

now whenever you need to switch between windows / workbook..
simply use..

Firstfile.activate or secondfile.activate

Hi Ted..

Thanks for feedback.. and rep..

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.