mac excel 2016

  1. C

    What is the mac equivalent of ctrl+j in the text to columns wizard?

    I'm writing a macro and one of the steps involves splitting multiple rows in one cell into their own separate rows. What is the equivalent of hitting ctrl+J in the text to columns wizard? I've already tried ⌘+J, ^+J, and ⌥+J, but those aren't working. If anyone knows of a chart that lists the...
  2. K

    Function .Activate and .Close not working on Mac/Excel 2016 - workaround?

    Hi team, I have a Macro that runs like a dream on a PC, but on the Mac (which is the computer I use) it does not. I've traced it to the two lines highlighted in red. The macro runs when I remove them, but that means I have to manually close hundreds of files. Is there a workaround or fix for...
  3. A

    How can I make my VBA code send a gmail on mac? (Currently using CDO but only works on windows)

    I have setup a file that automatically generates emails and sends them directly from gmail account. Unfortunately I only know how to do this using the CDO reference which is not available for MAC users. I need my code to work for both windows and mac user. Does anybody know how to do this...
  4. Computer

    How to change the cell reference of many formulas quickly?

    <tbody> Subject Start Date Start Time End Date End Time All Day Event Description Location Private Orient 1/7/2019 8a 1/7/2019 12p FALSE Spring Orient. Rm 681 TRUE LM 1/7/2019 1p 1/7/2019 4p FALSE Resume Building rm 681 TRUE LAB 1/8/2019 1p 1/8/2019 4p FALSE Skills Lab TRUE AH...
  5. A

    VBA Code help - Form control toggle button not working on Excel for Mac but fine on Windows

    Does anyone know what I need to change to get this VBA code to work in Excel for Mac? It works fine in Windows. It is a show/hide toggle for rows while the caption on the button changes as well. I used a form button (not ActiveX). Sub HideDone() Dim Shp As Shape Set Shp =...
  6. X

    Excel 2016 MAC .onkey for Command+V alternative

    As i have gone through almost entire internet and couldn't find a solution to address 'Command+V' for .onKey procedure in Excel VBA. Is there any alternative?
  7. V

    Latest Update Release for Excel on Mac

    Hi all, I have been advised that the latest update to Excel on the Mac has caused the below piece of code to stop working and showing an error message. Can anyone advise if this is a settings issue or does a new code need to be introduced with the latest update? Code that is highlighted when...
  8. N

    Checking Bookings - VBA Help Needed

    Hi Guys, Hoping someone could help me. I'm using Excel for Mac 15.39. I have a spreadsheet with two sheets, shown below: 1. Calendar <tbody> 23/10/17 24/10/17 25/10/17 26/10/17 27/10/17 30/10/17 31/10/17 01/11/17 02/11/17 03/11/17 more dates ---> John Doe Jane Doe...
  9. D

    VBA code no working on MAC (working fine in windows) + two other logic

    Hello Experts, I have below code which works just fine in creating TXT file of some columns in windows version. But in Mac its not updating the text file at all. Sub ExportTXT() Dim FirstRow As Long Dim Lastrow As Long Dim r As Long Dim Data As Variant Open...
  10. D

    Form Listbox problems on a Mac

    Trying to convert a few spreadsheets originally written for PCs using activex controls to something that will run on both a Mac and PC. I have successfully converted to form controls, and have a version that will function properly on both types of computer...sort of. There seems to be...
  11. F

    Help with Amending VBA Mac code

    Hello my Peers, I have the below VBA code that will import to a worksheet, can I please get your advice on how do I amend the code so it creates a new worksheet per import and renames the tab with cell a3 from the imported worksheet. Also is there anyway of keeping the structure of the...
  12. V

    VBA Issue with Runtime Error

    Hi all, I was wondering if i could get your advice, with the below error message and how can i go about fixing this issue on my Mac. I have searched high and low for a mac solution to a fix. this is the code thats failing: ExportWorkbook.SaveCopyAs ThisWorkbook.Path &...
  13. V

    VBA advice to change code to work on a mac

    Hello my peers, I have the below code that works on my windows machine however fails to run on my mac machine. can i get your guidance on how i can amend this to work on my mac machine as well as windows. [code Sub listFiles() Dim varDirectory As Variant, flag As Boolean, i As Integer...
  14. V

    Delete Hidden/Invisible Rows after Autofilter Excel VBA

    Good morning peers, I guess this is pretty straight forward, but for some reason it just does not seem to work for me :( I have the below code which auto-filters the data in row A39 based on the criteria that I have specified in Cell A1. What I am now looking to do is delete all the Unfiltered...
  15. V

    VBA filter data by cell value

    Good morning all, I was wondering if anyone has come across a code which can filter data based on a cell value. For example: If i have a number in cell A1 say = 2. (which is a formula) and Column Header in in row A39 through to AF39 and metadata below. Code to apply filter and in column...
  16. H

    Extract text from multiple sites on a Mac

    Hi all - first time poster, long time follower here! I have a website https://www.top10erp.org/erp-software-comparison-distribution-industry-164 that contains a table with a load of links. Each link takes you to a different (non-indexable) page. I'd like to copy the body of text from each page...
  17. F

    VBA code to action 100 files in a folder

    Is it possible to write a macro that would action all files in a certain folder with the below code? The folder name and location will always stay the same but the name of the files within and the amount of files may change. The macro would open them all, and run the below piece of code...
  18. V

    Mac Folder Location Question

    Hi all, I found the below code on another forum that will loop through files on a normal windows machine with a network location. However I am using a mac and i was wondering if anyone knows how to amend the code so it works on a mac. Sub Macro1() '//Change the path to the main folder...
  19. F

    VBA Automatic Import of over 500 spreadsheets

    Good afternoon, I was wondering if anyone can advise if there is a piece of code within VBA that you can use to run to import any documents that are in a network location. I have a project document which is the master document. As part of the process I need to bulk import over 500...
  20. V

    Copy and Paste into 300 tabs in a workbook

    I hope everyone is having a nice day. I was wondering if i could get your advice i have a tab called template which i want to copy into all 300 tabs in the workbook. Each of the 300 tabs is called something different. My Q. is there a VBA code that would do this. 1. Copy the tab data from...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top