+ Reply to Thread
Results 1 to 3 of 3

VBA code not working when i copy paste same VBA code in different file

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    VBA code not working when i copy paste same VBA code in different file

    I attached two file there is same VBA code in both files but that VBA code work in first file & not working in second file
    you can see in first file in cell N13 & cell N49 there is same number which is 2419 whenever this happen it means when same
    number occur VBA code do the sum of both values of cell Z13 (value of Z13 1078839) & Z49 (value of Z13 60607), sum of both values is 1139447
    put that sum in first cell (here is cell Z13) & put zero in another cell VBA code do that sum for every same number
    but that VBA code not work in second file
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    05-13-2023
    Location
    Venera
    MS-Off Ver
    2007
    Posts
    79

    Re: VBA code not working when i copy paste same VBA code in different file

    Problem is the line in macro j3v16()

    Please Login or Register  to view this content.
    it should be

    Please Login or Register  to view this content.
    It started from cell N9 in first.xlsm,
    but in the second.xlsm it starts from N5,
    so I set it to start from N1.

    Here you go.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: VBA code not working when i copy paste same VBA code in different file

    Thanks now my problem is solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. copy paste code not working
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2015, 09:16 PM
  2. Code not working - copy and paste.
    By RandomPezzer in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-03-2014, 03:13 PM
  3. Code to copy and paste cell value from last used row to new row not working
    By figbash in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2014, 02:02 PM
  4. [SOLVED] Code to copy and paste not working
    By missit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2014, 10:27 PM
  5. Code: Find, Copy, Paste not working
    By ufopilot3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-26-2012, 03:40 PM
  6. VBA Copy Paste Code not Working...
    By geng in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2010, 10:30 PM
  7. Code not working exactly, copy and paste issue
    By jpthelpguy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2009, 01:42 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1