+ Reply to Thread
Results 1 to 6 of 6

PC Macro only partially working on Macs

  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    Dracut, MA
    MS-Off Ver
    2010
    Posts
    3

    PC Macro only partially working on Macs

    Hi:

    I' have a workbook done on a PC in Excel 2010. When the workbook is opened on a Mac, all of the macros work except for one. The macro in question performs some formatting on cells in column A, but the formatting is not quite right.

    For example, one of the things it's supposed to do is center the text in each cell. It does this correctly on a PC, but on Macs it left justifies the text.

    Below is the relevant code:

    Please Login or Register  to view this content.
    Any help would be greatly appreciated,

    Thanks - Steve

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: PC Macro only partially working on Macs

    remove this
    Please Login or Register  to view this content.
    and it will center properly
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: PC Macro only partially working on Macs

    I'll have to take JP's word on the actual solution ... I don't have a MAC to test it.

    However, the macro could be shorter, with the same results:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    09-19-2014
    Location
    Dracut, MA
    MS-Off Ver
    2010
    Posts
    3

    Re: PC Macro only partially working on Macs

    Thanks JP. That did the trick. Much appreciated. - Steve

  5. #5
    Registered User
    Join Date
    09-19-2014
    Location
    Dracut, MA
    MS-Off Ver
    2010
    Posts
    3

    Re: PC Macro only partially working on Macs

    Thanks TMS. I'll clean the code up as you suggested. - Steve

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: PC Macro only partially working on Macs

    You're welcome.

+ 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. PDF Macro works with windows but not on macs
    By chonkies in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2014, 06:13 PM
  2. [SOLVED] Scripting Dictionary - CompareMode only partially working...
    By Zoediak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2013, 03:40 PM
  3. Macro only partially working
    By LilSisKin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-26-2013, 06:04 PM
  4. Nested IF formula partially not working
    By Mattacola in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-14-2012, 03:21 PM
  5. VLOOKUP partially working
    By ih8xc in forum Excel General
    Replies: 4
    Last Post: 05-03-2011, 08:32 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