how to get macro to run only in ThisWorkbook

Below is a section of code from a macro that just does some copy and paste special stuff. It goes back and forth from NEW EOD.xlsm, and EODHistory.xlsm. How would I go about making sure that it only does these things to the workbook the macro is in? This macro is called upon from another workbook, and I got some pasted stuff on another workbook that was running a macro at the same time. Thanks

Please Login or Register  to view this content.

Here is an example

Please Login or Register  to view this content.

This was the only way that I could get it to work, I think because of merged cells. When I would try to do more range's at once, I would get an error. I tried just copying everything on the tab (which is what im doing one at a time in this macro above) and pasting special, but it didn't work. I want everything on the tab copied over with formatting, etc...however, all of those ranges are referencing cells from other tabs...So I didn't want to just copy and paste the whole thing, because it copies the formulas. I just want it to copy and paste it, just how it looks. Because the same page is cleared by a macro everyday, and then new info is entered. The macro above just copies and pastes (one range at a time) until I have it all, and says it in another work book, so that we can go back and look at what was entered on each day.