mac excel

Thank you for reading my post. I am new to VBA and I was wondering if you could advise me or guide me in the right direction. I have the below VBA code to copy a worksheet to a new workbook and i was wondering is there a way to add to the code to automatically rename the workbook as the...

HI, I am new here and hoping someone can help! I have an updated 365 version of Excel on my macbook. When making pivot tables, I can right click on "refresh data" and the data will refresh with what was newly entered into the table. However, when I send these spreadsheets to non-mac users (it...

Greeting everyone, At my workplace, we're running into an odd problem. We create a weekly report on Excel. Normally, the preparer uses Excel for Windows to take last week's iteration and modify it for the current week. However, a couple of times when she has been out of the office, a Mac user...

Hello I hope you can help me as I am really new with macros in Excel I have a Purchase Order form that I need to get a new number every time I open the template and, when finished (closing/saving and/or priniting), the default saving name be a construction of fields and texts from within the...

When I run the following code on a PC (Excel 2013) it works fine. When I run it on a Mac I get a Compile Error (Expected Function or Variable) at the line: "With ActiveCell.SpecialCells(xlLastCell).Select" Sub import_reccurring_transactions() Application.ScreenUpdating = False ' name...

Hello Mr.Excel, I wrote a hide rows VBA on Excel 2013 (see the code below), it is working fine. But when I opened in MAC Excel 2011 the button is not working (it become static buttons). I have the button as "form control" Private Sub OptionButton_NA_No_Click()...

hey.. am student and i need help in my project where i have to create a long list in excel therefore i need auto complete tying in my mac excel so that whatever the previous entries i have entered in above column shows in my next cell also (write now its showing closest match entries and as i...

:eeek: After reading through some of the day's posts, one caught my eye. I don't want to panic if there's no reason. I created an excel worksheet full of VBA macros, formulas, modules, userforms, etc. I use Windows 8, some of my co-workers use Windows 7, but my boss insists on using a Mac...

Hi! So I have been pulling my hair our trying to figure out how to build a <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250...

I created an array formula in PC excel 2010, but a MAC user is not able to see the results of the formula. see below for the MAC's screenshot. https://dl.dropboxusercontent.com/u/52990313/Array%20Image.TIF cell D2 is blank when there should be a result from the formula. auto calc in MAC...

I need to connect to windows program another computer. The program has a winsock protocol running. I can telnet from the terminal of my mac and send and receive data. I would like to be able to do this inside excel with vba. I can imagine a separate program (ruby or something) that will do...

Hi, I have a small excel file with several macros. Works fine on a pc, but go to a mac and it does not function. Anyone got any ideas OR can look at it for me?

The code below does the following perfectly in Windows 1) automatically creating a folder structure based on entry in Column 3; and 2) automatically creating a hyperlink in the appropriate column. The code can be found below: If Not Intersect(Target, Columns(3)) Is Nothing Then Dim tr...

Are all the Data analysis toolpak add-ins (including solver) available in the Mac OS Excel? I've been thinking of transferring to an apple laptop and Excel is a big consideration since I do alot of Excel data tables. Thanks, Bannika

Ok, so I am very close to this and probably just need a pointer or two... What I am using: Excel for Mac 2011 What I Have: 300 rows of html text, exported from a website, that contain product titles What I am trying to do: Insert the word "Lenses" before the word "for" for each row. For...