+ Reply to Thread
Results 1 to 5 of 5

Macros not working like they use to

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2013
    Posts
    284

    Macros not working like they use to

    Hello,

    We recently upgraded to Windows 10 Excel 2016. We have files with macros that we have been using for months and some of them for years that are breaking down all of a sudden. Have any of you had this issue? Macros that simple copy paste isn't working or pulling formulas down a row of data ends up bombing out starting we've exceeded resources when we never had the issue before.

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,271

    Re: Macros not working like they use to

    what windows/excel/bits were the macros written in and performed well in? I presume 2013?
    I just ask because I have xp/2010/32 to 2012server/2013/64 issues in that space - although mostly with large macros.

    It sounds like you are saying these are simple macros? are they working on a lot of data? maybe you can show some example code.
    Last edited by scottiex; 12-06-2016 at 11:06 PM.

  3. #3
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2013
    Posts
    284

    Re: Macros not working like they use to

    majority of the macro works. it doesn't perform simple copy and paste parts of the formula or ripping down formulas to the last row. The code was built on 64 bit 2013 excel windows 7. The tool was then shared with people on 2010 excel windows 7. We recently switched to windows 10 2016 excel and they put us on 32 bit instead of 64 which I am working with IT to get corrected for my team but the rest of the financial department outside of my team will be on 32 bit. We haven't had issue in 2013 excel with crossing files between 32 and 64 bit excel though. Do you think if we copy the code from the 64 bit version into a new 34 bit version it may work? I would hate to have to do that because the workbook is pretty advanced with tabs for various calculations. Too large of a file to post here.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,596

    Re: Macros not working like they use to

    Can you post some examples of the code that's causing problems?
    If posting code please use code tags, see here.

  5. #5
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2013
    Posts
    284

    Re: Macros not working like they use to

    Sure let me get with one of the guys on my team that had the problem and pull the code. It was pretty simple copy a range and paste value code. and lastrow calculations to then copy a row with formulas on it down a large number of rows to the lastrow range. I will try to post shortly.

+ 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. Macros Not Working
    By mycon73 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-12-2018, 12:59 PM
  2. Macros not working...
    By mmcgrail in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-23-2013, 10:03 AM
  3. [SOLVED] Macros not working
    By ILoveStMartin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2012, 02:19 PM
  4. Working with Macros
    By odin13 in forum Excel General
    Replies: 1
    Last Post: 10-22-2009, 05:25 AM
  5. Macros are not working on a Mac
    By vjboaz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-23-2008, 03:25 PM
  6. XP macros not working in NT
    By DKS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2006, 06:40 AM
  7. Macros not working
    By neb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2005, 12:05 PM

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