mac excel

Hello. I have data in a large array that I'd like to be extracted into a single column, with each unique value having its own cell. All of the data are 8-digit integers that appear throughout multiple columns and rows. Some of the cells contain multiple 8-digit integers, which are delineated by...

Hi Team, We have a customUI ribbon and which calls external commads. While the external command macro is running and user is clicking on Excel multiple time then excel ribbons goes into greyed state. Even to select cell we need to double click. In this case if we minimize and maximize the...

Hello, Been looking for a way to populate corresponding time blocks for classes based on time ranges in another sheet. If anyone can help with either formula or VBA to get sheet 3 to populate how I need the data it is greatly appreciated. Sheet 1 contains blocks of times in 5 minute intervals...

Hello, I'm looking for some thoughts/suggestions on the best way to create a series of auto-updating charts. Previously I'd done the time consuming work of extracting via links (referenced cells) on a separate sheet but I'd like to see if I could do it agains the source data. Effectively I...

Hi All, I have the below piece of code which runs fine on a Windows PC but I need it to run on a mac and when I run it it keeps erroring at the save file stage. The issue seems to be with the directory, this is the one I use: /Users/stroffso/desktop Any help would be greatly appreciated...

Hello! I wanted to see if there was a way to Use VBA to create a .scpt file in the application scripts folder ("/Users/ComputerName/Library/Application Scripts/com.microsoft.Excel") on MacOS? I am able to read files from that folder using myfile = "/Users/" & Environ("USER") &...

I have attempted a number of options from what others have done to submit data from my created form into a data sheet. I need to submit the data from the form sheet to the data sheet, retain the information in the data sheet then give the option to refresh the form for the next input. This is...

Hi all, can someone explain why this error message is generated in Power Query for a user who uses a Mac and it doesn't appear for anyone else! Power Query Error Message: 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException'

I have tried the following and get no syntax errors: Sub Delete1000() Dim lngCol As Long Dim ws As Worksheet Set ws = ActiveSheet With ws For lngCol = .Columns("T").Column To .Columns("CYL").Column Step -1 If WorksheetFunction.Sum(.Columns(lngCol)) <=...

I working on a mac and cannot get SaveCopyAs where the path name name has 2 spaces in it. BTW: I have successfully tested this with a pathname with NO spaces. NOTES: I am running this on a Mac using Excel 365. Here is my code: Sub MySaveCopyAs() ActiveWorkbook.SaveCopyAs...

I have an Excel workbook with no external references and no VBA. There are only 4 worksheets in the file and on one of those worksheets, I use the INDIRECT formula to automate getting a value from a cell in a different worksheet in the same workbook. The formula is looking for a value from...

Hi All, I am using Mac and my team is using windows majorly. We have excel where windows user are able to see the data without any issue but i am getting #REF! in most of the cells. Weirdly , when i opened another excel which is connecting to DB and getting the data and then opened the above...

Hi! I have several forms with macros that run from the forms and progress bars that pop up while the macros run. I am running this sheet on Windows and Mac OS. On Mac, the forms are really slow and a the progress bar does not show until the very end. The sheet also "whites out" while the macro...

This is my 1st post on this website so please be kind :-) I want to pull some table from a website to excel and show them in Excel tables. You might be wondering why I don't use Power Query. Well I'm a Mac user.... I've already managed to pull the table that I want but I just can't figure out...

I built macros to automate a sales reporting process. I am leaving the company and trying to ensure the sales report will be usable after I leave. My boss who will be running the report uses a MacBook Air. When I run the macro, the first error that comes up says "Print - Error while printing"...

Hi, I'm looking for some help on why my code is working on a PC but won't work on a MAC. I have a sub that executes when the user uses the paste function to auto-format cells based on the data pasted in. I can't figure out why it won't work on a MAC. I thought it was because the control ID...

Hello! I've created a file which has some VBA Script for Autofilter search boxes and a Reset filter function. I've tested the file with several users and have found everything works perfectly on Windows but does not work on someone using Excel - Mac. The Mac users receive a Microsoft Visual...

I'm trying to create a spreadsheet to keep track of my inventory.I am using Microsoft Excel for mac on 365Column I, I would like to add new stock in to add to Column K which I can do by a formula using column J<tbody>=I+J</tbody>Ideally, I want a macro button or something that then deletes I for...

Hello, I was wondering if any of my peers can help me. I have the below VBA code that looks at Sheet ws2 and copies and paste data by matching the column header in Ws1 into the corresponding columns. However I can't seem to amend the code so that every time i run the code it pastes data...

Good afternoon, I have the below VBA code which references a cell in another tab of a project document and returns the data from my SBD_Data tab. With Range("W6:W2151") .Formula = "=SDB_Data!V8" .Value = .Value EndWith However, the issue i can't seem to resolve is that the cell that...