Closed Thread
Results 1 to 2 of 2

MACRO tO Copy Ranges from 2 Closed Workbooks

  1. 01-14-2022, 01:15 PM #1
    Floydlevedale
    Floydlevedale is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Cape Town South Africa
    MS-Off Ver
    Excel 2007
    Posts
    133

    MACRO tO Copy Ranges from 2 Closed Workbooks

    Hi

    I need a Macro that will copy a Range of Cells from BOOK 1 ( A1:A18 ) and BOOK 2 ( B1:B12 ). The File Addresses D:\EXCEL FORUM\Book1.xlsx & D:\EXCEL FORUM\Book2.xlsx. Destination Work ( in which Macro is run can have same file address.

    Thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-14-2022, 01:57 PM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,036

    Re: MACRO tO Copy Ranges from 2 Closed Workbooks

    You have made a duplicate thread for a second time. DO NOT do this again. One thread per topic. Thread closed.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel VBA Loop Macro - Copy Different Ranges and Paste into Multiple Workbooks
    By Hoover5896 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2017, 08:47 PM
  2. Copying specific data ranges from multiple (closed or in use by others) workbooks
    By TheRetroChief in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2014, 10:39 AM
  3. [SOLVED] Macro to copy non continuous ranges in closed worbooks based on user input
    By Chrispelletier in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-07-2014, 07:49 AM
  4. Sum Variable Ranges based on user input - Data in closed workbooks
    By alexfortin1 in forum Excel General
    Replies: 3
    Last Post: 02-20-2011, 06:30 AM
  5. Copy a range from closed workbooks (ADO)
    By guitar187 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-21-2010, 05:15 AM
  6. Copy a range from closed workbooks (ADO)
    By guitar187 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2010, 12:14 PM
  7. Copying ranges of cells from closed workbooks?
    By JHongTurney in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2005, 03:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1