mac 2011

Hi Everyone, I'm on Excel Mac 2011 & would like to hide the formula bar via a VBA script. The traditional "Application.DisplayFormulaBar = False" does not work in the Mac version for some odd ball reason. I can hide every other tool bar & ribbon, just not the formula bar. Anyone know of a work...

I have a userform combobox that draws its list from a column, then eliminates the duplicates, then alphabetizes the list. I am writing the code in the Office 2013 for windows version of Excel. The application is being used on a Mac, Excel 2011. Everything works great, except when you begin...

Hi All I'm trying to link to a dynamic range based on the input in a different cell. I'm using indirects in data validation to call up the correct range. For some reason it isn't working even though I've done it hundreds of times before on a PC. I am on a Mac on Excel. I have two 'Macro...

Hello all, and thank you for whatever help you can provide. I am using excel to look at historical financial data. I have used a query to pull and update historical stock data from Yahoo Finance. I need to lookup the cell with the lowest value, return that value and the date of that value to...

This is my first post here. I'm using a MAC with OSX El Capitan and Office 2011. I believe the newest update of Office or the new OSX upgrade made these changes to the Excel program. I've looked at all the possible preferences to remedy the problem but can't seem to find any solutions. 1 ) When...

Please forgive if this has been covered, I searched but there were *so* many posts on the general topic and the first bunch I looked at were all Windows-only solutions, so I decided I just needed to post anew. I'm on Mac Excel 2011, so there is no Pivot Table Wizard. I have 4 workbooks, each...

Hi, I'm trying to produce a copy of a complex userform I have in Excel 2011 (for Mac). Following advice on other forums I have exported the user form, renamed the associated .frx and .frm files (which were the only exporting options) and am now trying to import back into the original workbook...

I've been scouring the interwebz only to find loads of solutions that worked years ago, work on Windows, or for some reason don't seem to do a darn thing for me. Could be I'm making mistakes, wouldn't be the first time. But it also wouldn't be the first time an issue was specific to Mac Excel...

We have a macro that is working fine in windows, but the same is not working in excel for Mac 2011. Herewith attaching my entire code with the change you have suggested... and also attaching the error message. Code...

I have a large number of data sets, and my code goes through each and runs solver on each. The macro works flawlessly on Excel for Windows. Upon looking into this problem it is a known one, yet there aren't any solid solutions to bypass/fix this issue. What happens is the VBA macro runs...

An outline of my code is as follows; 1. Copy single column of data from raw data sheets, of which there are 5 in a separate workbook, to the curve fitting sheet (different workbook). 2. Run solver on these data to minimize the sum of the squares. 3. Copy the output to the i'th row of column...

How do I add a two color gradient fill to a cell on a Mac Excel 2011? I can only figure out how to add it to a shape or a chart, but I need to add it to a single cell. Thank you!

So I have the following table (though much longer, thousands of rows), and I need to make it look like the second table. That means taking the number in P Type and paste it down in P Level until the next number in P Type, where I repeat the process, and so on (observe the difference between the...

I want to create a progress bar on Excel for Mac 2011. I used Conditional Formatting > Data Set. I followed this method: www.tech-recipes.com/rx/35064/excel-2013-create-progress-bars/ This normally works for Excel on Windows. On Mac Excel, it fills half the bar and never changes according...

I am in need of help for VBA code to paste a formula that I will have copied into the clipboard into empty cells only of a range of cells. Example, my formula is: =IF(ISNA(VLOOKUP(F100,gpcucndata,3,FALSE)),"",IF(VLOOKUP(F100,gpcucndata,3,FALSE)=0,"",VLOOKUP(F100,gpcucndata,3,FALSE))) I need to...

Hey guys, First off I'll start by saying I'm decent at best with excel.. So don't expect me to know a whole lot, so don't be afraid to get "laymans terms" with me.. I know what I'm good at, and excel is NOT it. That being said: I have a master list of email addresses with corresponding...

I am using excel in Mac. I have multiple drop-down lists with some of the validations being indirect. I would like to search within the lists to make it easier to choose from it. I do not want to add more columns or formulas in my excel, since it is a huge amount of information. I simply want a...

Hello - I have a workbook that have multiple sheets. The sheets have the same data structure. How do I combine them into one without doing copy and paste? I tried using consolidate, but consolidate does aggregate on the values. In my case, I don't need to do any aggregation. It is all text. I...

Hi, I have racked my (limited) excel brain and cannot find a suitable way to do the following: Convert all files within a folder from HTML (downloaded from browser) to xlsx format. I wish the following considerations to be adhered to: Files will always be within the same folder on my...

Hi All, New to Macros (Excel for Mac 2011), but am hoping someone can hep me out. I am looking to take a large and growing database of names followed by string of text all in column A and have them separated into two cells I am currently dealing with the following (names have been changed for...