+ Reply to Thread
Results 1 to 11 of 11

Excel 2011 for Mac: Macro Recording Error: What's going on?

  1. #1
    Registered User
    Join Date
    11-24-2013
    Location
    Western USA
    MS-Off Ver
    Excel for Mac 2011 & Excel 2013 (PC)
    Posts
    11

    Excel 2011 for Mac: Macro Recording Error: What's going on?

    Microsoft People! What the heck is this all about?! It's my conclusion after looking into this issue that the macro recorder in Excel for Mac 2011 must simply just suck. While working with tables of data, selecting variable rows is something people do all the time and Excel for Mac 2011 managed to screw it up. Here's how:

    Control-Shift-Down (Excel for PC)
    Sub Macro6()
    '
    ' Macro6 Macro
    '

    '
    Range(Selection, Selection.End(xlDown)).Select

    End Sub
    -------------------------

    Command-Shift-Down (Excel for Mac)

    Sub Macro1()
    '
    ' Macro1 Macro
    '

    '
    Range("A1:A31").Select


    End Sub
    --------------------------

    How is the Macro Recorder on these two platforms doing such different things on such a simple and commonly used command? Explanation? And is there a keyboard shortcut in Excel for Mac 2011 that actually records "Range(Selection, Selection.End(xlDown)).Select" instead of simply the specific range??

    Because this is such a simple function, it makes me nervous to record ANY sort of complex macros for work (PC) at home (Mac). It makes me wonder what else could've been possibly overlooked in the Macro Recorder programming in Excel for Mac 2011.

    Thoughts?

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Excel 2011 for Mac: Macro Recording Error: What's going on?

    isnt the short cut Ctrl-Shift-Down on a mac as well? or is that a typo or a different keyboard?
    Attached Images Attached Images
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    11-24-2013
    Location
    Western USA
    MS-Off Ver
    Excel for Mac 2011 & Excel 2013 (PC)
    Posts
    11

    Re: Excel 2011 for Mac: Macro Recording Error: What's going on?

    No. The ctrl button on Mac is reserved for system operations. Ctrl-Shft-Down Arrow moves the active windows and shows the desktop. Good question, though.

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Excel 2011 for Mac: Macro Recording Error: What's going on?

    not according to everything i've seen .... from here for example
    http://www.wallstreetprep.com/blog/s..._shortcuts.pdf

    Highlight contiguous items SHIFT + CTRL + Arrow keys
    however further looking says this which contradicts the above
    http://office.microsoft.com/en-gb/ma...102927337.aspx
    Extend the selection to the last nonblank cell in the same column or row as the active cell COMMAND + SHIFT +arrow key
    Last edited by martindwilson; 11-24-2013 at 09:13 PM.

  5. #5
    Registered User
    Join Date
    11-24-2013
    Location
    Western USA
    MS-Off Ver
    Excel for Mac 2011 & Excel 2013 (PC)
    Posts
    11
    I'm pushing it right now and, no, it is working as I described. No typos.

  6. #6
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Excel 2011 for Mac: Macro Recording Error: What's going on?

    ,unfortunately i dont have access to a mac at the moment. it may well be a bug have you all the latest updates for 2011?

  7. #7
    Registered User
    Join Date
    11-24-2013
    Location
    Western USA
    MS-Off Ver
    Excel for Mac 2011 & Excel 2013 (PC)
    Posts
    11
    Definitely. I've been working with this issue for awhile

  8. #8
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Excel 2011 for Mac: Macro Recording Error: What's going on?

    well unless anyone here knows better i suggest you try microsoft
    http://office.microsoft.com/en-gb/ma...in=HA103526326
    but i dont hold out a lot of hope there
    in the mean time i've asked some others who may have a mac to have a try
    Last edited by martindwilson; 11-24-2013 at 09:50 PM.

  9. #9
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Excel 2011 for Mac: Macro Recording Error: What's going on?

    There is nothing to make the macro recorder work the same way on a Mac as it will on a PC. They are different code bases. Like many things in Mac Excel it does work up to a point but not as well as the PC version.

  10. #10
    Registered User
    Join Date
    11-24-2013
    Location
    Western USA
    MS-Off Ver
    Excel for Mac 2011 & Excel 2013 (PC)
    Posts
    11
    Izandol: your reply seems like a longer way of saying, "it sucks"

  11. #11
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Excel 2011 for Mac: Macro Recording Error: What's going on?

    Yes.

    I find Mac Excel very hard to use and do not program with it unless I must. But we must be fair - 2011 is progress anyhow from 2008!

+ 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. Recording Macro to create a Pivot Table in Excel 2013: run time error 5 invalid procedure
    By developerstew in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2013, 07:17 AM
  2. [SOLVED] VLookup error in Excel 2011 for Mac Macro
    By zuck in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-20-2013, 04:34 PM
  3. Replies: 2
    Last Post: 11-26-2012, 08:33 AM
  4. [SOLVED] Macro/vba to change date format from 01.01.2011 to 01/01/2011
    By Darrenh1238 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2012, 07:42 PM
  5. Excel 2011 Macro error "Method 'GetOpenFilename" of object'_Application'failed
    By rfox69 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 09-26-2012, 08:35 AM

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