1. B

    Excel for Mac 2011 equivalent of ctrl+shift+j

    I am trying to use Find and Replace to find the pipe symbol (|) and replace this with a carriage return. The ctrl+shift+j does not work for me on the Mac keyboard using Excel 2011 for Mac. If I go into my VM running windows and Excel, then it works just fine. Thanks, Benje02
  2. G

    Lack of Memory posting Excel object to PowerPoint

    When copying and pasting MS Excel (Mac 2011) into PowerPoint, receive error "Not enough memory available to read worksheet". I saw a similar post in 2010 with no responses. Thanks for any advice
  3. O

    Excel (Office for Mac2011)- all menus greyed out

    Hi Have been running Excel for Mac 2011 for years now. Just this week all my Excel menus were greyed out (not so for Powerpoint or Word). Have uninstalled (completely based upon instructions obtained from Microsoft website) and reinstalled. Still makes no difference. Any ideas why this is...
  4. U

    Store date and time in a variable in Mac Excel 2011 vba

    I have been able to do it fairly easily in Windows using the code <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace...
  5. A

    From Apple MS 2008 to Windows 2010 - Are there any Excel compatibility issues?

    Excel Friends, Any of you have experience with this issue or can point out a good link to read about it: FROM Apple MS 2008 TO Windows 2010 - Are there any Excel/Office compatibility issues? Thanks!
  6. D

    VBA for MAC navigating in internet

    I have a Google Analytics Macro that works perfectly fine in Windows, but I need to use it in MAC. I am having trouble opening a browser and navigating in it, including this code here: Set HTMLDoc = oIExplorer.document HTMLDoc.all.Email.Value = GAlogin ‘this is a string I got in another...
  7. M

    Blue border appearing around everything I select

    Earlier today a blue border began appearing around everything I select, to include tables, cells and even individual characters within a cell. I am using "Normal" view and am at a loss as to how to turn this off. I do not have a print area set. I'm using Excel 2013 on Parallels 9 on my MacBook...
  8. Data Bender

    Macro to Send Email from Mac w/o Attachments

    Ron de Bruin's work is wonderful (and cited seemingly everywhere). Yet, I simply want a macro to send an email without attachments, from either a PC or a Mac. The following is my latest attempt (in Windows): Private Sub Workbook_Open() 'Email via Outlook Dim OutApp As Object Dim...
  9. P

    finding duplicates and concatenate

    Hi, i'm using excel 2008 for mac, so i can't run any VBA or macros, just formulas! can any one help me?? i have this cells listed below <!--StartFragment--> <colgroup><col width="65" span="5"> </colgroup><tbody> 1B 1C 1D 1E 1F DRAWING DRAWING...
  10. J

    Mac recorded Macro does not work with windows. Run-time error 1004

    Hello all, I have been given a macro recorded on a mac and it works fine with Mac Excel 2011. Unfortunately, I need to make it to work on a windows machine, but it comes up with an error message "macro unable to set width property of the window class. Run-time error 1004". When I press debug...
  11. T

    Module & MS Query Compatibility From PC To Mac

    I have an spreadsheet which has Excel tables with team data on. On one page I'm using an MS Query with SQL to query these tables. Here's the original thread (If you really want to know)...
  12. L

    Solver Error 1004 - Application-defined or object-defined error (mac)

    Hi I´m having problems with Microsoft Excel for mac 2011 (update 14.1.0 with Solver add-in from I´m trying to use the solver but when I ask it to "Solve" I get a window from Microsoft Visual Basic where it says: Run-time error '1004': Application-defined or object-defined error...
  13. K

    Web Query Mac

    I'm having a really hard time making web queries on Mac. I'm trying to import the individual words from different news articles into different columns. So, ideally, each row would have all the words from all the articles on a certain day. Whenever I use this code: WEB 1...
  14. J

    How do I work with UNC/NFS Network Files from a Mac using VBA in Excel 2011?

    Hi All, Google isn't being my friend when it somes to searching for answers to this, so I'm hoping someone on here can help me instead. :) The following code in Windows Excel 2010 returns True or False, but I just can't figure out how to check for a networked file from within VBA on a Mac...

    Autocomplete as you type drop-down list. Possible? (Excel Mac)

    Hi folks, I've looked high and low for a solution to this. I found nothing, so I am thinking it's not possible. And yet I find that hard to believe... so I am hoping an Excel pro can prove otherwise. I have lists with in excess of 10,000 entries. Some have a few thousand, some over 10K. What...
  16. Ron de Bruin

    Update Mail code for Mac Excel 2011 with Outlook

    Hi all If there are Mac users in this forum I like to share some mail code for Mac Excel with Outlook. Send Mail from Mac Excel I changed the mail function so it is easy to add more then one person in the To, CC and BCC and add also a option to add more then one attachment, Also a example now...
  17. A

    Sending multiline email using a Excel 2011 on the mac

    I am trying to send a multiline email using a macro in Excel 2011. The problem is that it isn't sending a separated lines it just ends up all bunched together. Can anybody give me any help? This is what I have right now Sub MailBody() 'Generate Email Address emadd = "" & UserName &...
  18. D

    Conditional Formatting "Applies to" Range Changing

    I'm currently using a workbook that I edit daily and save on a flash drive to pass on to a co-worker each day for his use. I have Excel 2011 for Mac, and he uses Excel 2010 for PC. On one of the sheets in the workbook, there is a list of contacts with columns A through U containing unique...
  19. S

    Porting Macro to Mac - Compile Error

    I've developed a macro on Windows that works perfectly, I had a problem with the opening of files - now I have a problem saving the file. Here is the code tossing the error: Sub asktosave() Dim sav As Integer Dim file_name As Variant sav = MsgBox("Would you like to save this file?", 4...
  20. N

    Return username with VBA on Mac

    Hi! On Windows I can use the following to return the username of whoever is logged into the computer: Environ("username") But this does not work on a Mac. How can I replicate this? P.S. I found something that returns the machine unique identifier but that is not what I'm looking for.

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...