LinkBack URL
About LinkBacks
Jocote46 
assuming you are running the code while file "A" is open and active
you can replace Workbooks("04.10.17 SHELBY.xlsx") with thisworkbook
ie
Thisworkbook.Worksheets("Summary $500-$10K").Range("B8:F21").Copy
assuming you are running the code while file "A" is open and active
you can replace Workbooks("04.10.17 SHELBY.xlsx") with thisworkbook
ie
Thisworkbook.Worksheets("Summary $500-$10K").Range("B8:F21").Copy
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks