mac

I have generated thousands of lines of software using macro 4.2 in Excel V5. This is business and accounting software and was produced on a G3 Mac. I have transferred it to G4, G5, Power Mac and (the latest) iMac. I have also generated other software in macro 4 which runs successfully on all...

A couple of months ago, I found some code online to create a delay when running VBA code, called SleepSub. I needed to use it because on Excel for Mac, some labels on my UserForms were not updating on the screen, even when I would use the Repaint method. (I think the labels were changing too...

I have a line graph in Excel on Mac. The size and location of the labels on the axis change based on the width of the characters included. Wider labels get slightly smaller and move up higher. Smaller labels remain larger and stay on the bottom. These are all the same number of characters...

I'm making a workbook for both Windows & Mac. I have a button in my workbook that allows them to PRINT worksheets, and another that allows them to make a PDF of worksheets. Both buttons work perfectly on Windows. On Mac 2016/2019/365, the PDF button works fine. It’s the PRINT button that...

Hi, I've got a piece of code I found online and it works awesome in Excel for Windows. It takes a long list of data and saves out separate files for each unique value in column A. However, when running it on Excel 2019 for Mac, it does not use the unique values in Column A for the file name, but...

Hi everyone and thanks for taking a look at my question. I would really appreciate any assistance! I have created a sales quote template for my company. Some of our sales people use Macs and other use PCs. When going to print a quote, it is necessary to select three different tabs. Sometimes...

Looking for best approach to doing various analyses of data, some of which is pretty extreme time measurements--at least extreme compared to what I'm used to working with... Some is in what I'll call ss0.ssss format and some is in hhh:mm:ss.ssss format from a non-Excel source of course. I use...

I code almost exclusively for PC, but occasionally have to code for MAC. I often write SQL to query data and I typically use the Microsoft ActiveX Data Objects 6.1 Library. When running such code on the MAC, the user received a Can't find project or library error. This occurred on the line of...

I code almost exclusively for PC, but occasionally have to code for MAC. I always use [ and ] to reference ranges (e.g., [MyRange]), but this does not work on a MAC. Does anyone have any idea why, and how to make it work on a MAC?

I have an extremely long formula I am trying to modify. I originally wrote it on my work computer on windows excel. To allow me to renunderstand the formula I need the parentheses that match to blink when scrolling through the formula. It does not do this on the Mac excel 2019. Is there a...

Hiya This code works on Excel 2016 for Windows and Excel 2012 for Mac, but stops with the above error on Excel 2016 for Mac. Apparently it does not recognise the property 'Parent' anymore...? Public Function Whole_Row(rngFirst As Range) As Range Dim rngLast As Range Set rngFirst =...

Hiya Very quickly, I have gotten into the habit of passing data to and from arrays and then sending the arrays directly to workbook ranges. This has sped up my code considerably. When I have to transfer a series of non-contiguous columns the speed increase is still considerable, but I have...

Hi there, I am trying to filter a very long list of data using a drop down in a pivot table. When I click on the drop down, the list comes up in an unreadable jumbled mess. A lot of items on the list are very long so they take up a few lines. This is a new spreadsheet I am working on, but I...

Good Day I m trying to capture MAC Addresses on computer onto a user form. When capturing the NAC Address the cell is returning a value of True whereas I want the cell to display the MAC Address. My code is as follows: [CODEws.Cells(iRow, 40).Value = Me.TextBox77.Value =...

Get a message about a circular ref.when opening WM. Can't find the problem cell(s). Error Checking does not identify it; status bar indicates "Circular Reference" on each sheet but doesn't i.d. the cell. Can't find the error by inspection. Ideas? Please note: Excel for Mac (up to date). Thanks...

Hi All, This code was written by someone else who I lost contact with. This macro saves worksheets to PDFs from a list of worksheet names in column A. It then only prints the number of pages in column B per sheet only if there is a yes in column C per sheet. Before it saves, a prompt will ask...

Hello,I have created a excel VBA macro in windows7 operating system to populate PDF.Macro runs fine i win7 but in MAC operating system it gives error: MakePDF error: 53 file not found: shell32.dll VBAproject. Though On Mac it creates a FDF file. The code is.. ' Write FDF file to disk...

For a couple of years, I've been using a macro in Excel on Windows 10 (running in Parallels on my Mac) that will export each worksheet in my workbook to a separate PDF, saving all of them in a Desktop Folder on my Mac called "ExcelPDFReports" . . . here's the code that works perfectly: Sub...

I just added a handful of macro buttons to my ribbon (using Excel for Mac) in customizing my ribbon. On the Windows version of Excel, when you create or rename the button being added to the ribbon, a symbol / icon palette appears, allowing you to choose the icon you want to appear above the...

Does anyone know how to turn off screen updating in Excel VBA on a Mac? Application.Screenupdating = False doesn't work on a Mac. Thanks.