+ Reply to Thread
Results 1 to 1 of 1

Nested For Each loop for 2 range variables

  1. #1
    Registered User
    Join Date
    06-02-2013
    Location
    Ireland
    MS-Off Ver
    Excel 2003
    Posts
    2

    Nested For Each loop for 2 range variables

    Hello,

    So I have 8 files already opened for which I have to copy the data and paste it in 8 tabs. So I have 2 variables, the Files and the Tabs. With the code I'm trying the macro copies the content of each file, but paste it 8 times in the first tab! I tried the loop in another order but it happened something similar, it copied the content of the first file in the 8 tabs. What should I do so the code opens the first file and copies its content to the first tab, second file to the second tab, etc?

    I add the code:

    Please Login or Register  to view this content.
    Thanks a lot!
    Last edited by arlu1201; 06-03-2013 at 12:19 PM. Reason: Use code tags in future.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1