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?
Bookmarks