mac 2016

Hi all, Im trying to create a vba codes that work on both windows and Mac, Windows is fine but it doesnt work on Excel 2016 for Mac, it will goes directly to "Print" page to choose printer and print (without exporting to pdf and saving pdf file under a specific name referring cell in the...

So, I'm about to loose it with this one... :) I've sketched a file in my work pc (MS Professional Plus 2016) and when I open it in my mac (MS Excel for Mac 16.41) a formula is not returning the same value. In fact it returns "0". Maybe this is simple, but I don't quite understand what to do...

Hi, How to get deference between two dates in mac excel 2016 i tried but it is not working accurately Refer screenshot Ex: date - date2 =( 2 years 4 months 11 days) in one cell

Hi everyone, I was using the distinct count function in pivot tables so it doesn't count duplicates. To have it available, the flag "add this data to data model" must be marked when inserting the pivot table from the data source. This has always been very helpful to me. I am using Mac now, and...

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

Hi, I got the following code thanks to MickG here on this forum, which helped me a lot! It worked on Excel on Windows, but on the Mac, where it's gonna be used, it doesn't.. I imported the Dictionary.cls and KeyValuePair.cls from https://sysmod.wordpress.com/2011/11...ng-dictionary/, but I...

I am using Excel version 16.9 for Mac. Evaluate works if the returning value is an integer but not if it is text. The following code returns `Error 2029` when evaluating the RetText function. temp = Evaluate(RetText()) temp1 = Evaluate(RetNo()) Public Function RetText() As String...

I'm trying to save a sheet in the spreadsheet as a PDF, when it's ran I get the grant permission dialog box as well as the dialog to set the location and specify the file name. The file names are pre-set based on the FN value passed. Example: FN = test.pdf I want to completely bypass the both...

Good evening, I am using a mac and I was wondering if anyone has ever come across a piece of VBA code that will count how many row data there are in a workbook in a folder. For example: If i Have a folder with 158 workbooks in can a macro count how many rows with data in are in each workbook...

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

Thank you for taking the time to read my post. Im sure everyone has been asked to create multiple tabs at some point in their life while working with Excel, However I have been asked to create several hundred and i don't really want to spend my weekend loosing my marbles. Please can I get your...

I hope everyone is having a good day :-) I was wondering if there was a formula or VBA code that you can recommend or point me in the right direction for looking at data from different tabs and populating them into the master tab. I have summary document and in column B4 - B23 is the tab Name...

Hey guys, Firstly a massive thank you if anyone can help me! I am trying to run solver using VBA in Excel 2016 for Mac. I have installed the Solver Add-In and selected it from the references section on VBA Editor. However, whenever I try to run the macro I receive the following error: Compile...

Hi everyone, I am trying to automate a task to save time but my VBA knowledge is very limited. Hoping someone can point me in the right direction. I know that this question has been answered many times, but I have not been able to piece together code that works for my situation. Part of this...

Hi Looking for assistance for the changes in syntax from 2011 to 2016 mac for creating a new folder and then a save as version of a file with data that is firstly entered into a user form that loads into a spreadsheet. Thank you in advance. Dylan