Top "Excel-2011" questions

Excel 2011 refers to the spreadsheet editor included in Microsoft Office for Mac 2011.

VBA Simple Copying one Range to Another Range

This is a really simple VBA formula but it's failing. It's only pasting into cell A6 onwards. Is it just …

vba excel-2011
Solver.xlam is missing?

I created a program in Excel 2010 on my PC that relies on the built-in solver for Excel. I made sure …

excel vba macos excel-2013 excel-2011
Expected End of Statement in formula with quotes

Sub FillNames() Range("D2:D56").SpecialCells(xlCellTypeBlanks).Formula = _ "=IF(AND(C>800,C<900), "YES", "NO")" End Sub I get …

excel vba excel-2011
Where is Go To Special in Excel 2011 for Mac?

Does anyone know where the Go To Special... in Excel 2011 for Mac? In Windows, you can use Ctrl+G, but …

excel-2011
Excel: count number of times a value occurs in a column

Gah, I know this has to be easier than I am making it out to be: I have a simple …

excel excel-formula excel-2011
What does "=R[-115]C" mean in VBA for Excel 2011 on Mac?

What does "=R[-115]C" mean in VBA for Excel 2011 on Mac in below code? Range("F171").Select 'to select …

excel vba macos excel-2011
Load contents of CSV file to array without opening file

I have a requirement to collate over 6000 csv files into a single csv document. The current VBA process is: 1. Open …

arrays excel vba macos excel-2011
Excel if cell exceeds certain value use difference

I can't come up with the right formula for this. Cell B3 contains a value. In cell C3 is the …

excel excel-2011
Sumif between two dates over two columns

I would like to sum a column between two dates, however the dates are in separate columns. I want the …

excel date excel-formula excel-2011
Waiting in Excel Macros

I am recording an Excel Macro where I would like it to wait half a second before switching to the …

vba excel excel-2011