mac excel 2016

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...

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...

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...

<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...

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 =...

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?

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...

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...

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...

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...

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...

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 &...

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...

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...

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...

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...

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...

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...

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...

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...