Excel 2011 refers to the spreadsheet editor included in Microsoft Office for Mac 2011.
Questions tagged [excel-2011]
151 questions
0
votes
1 answer
Reset Excel StatusBar with AppleScript on Mac
I can't reset the Excel StatusBar from AppleScript (Excel for Mac 2011 on Mavericks).
Setting a value works:
tell application "Microsoft Excel"
set status bar to "Test"
end tell
But resetting it writes falseinstead of Readyinto the…
Felix Zumstein
- 6,737
- 1
- 30
- 62
0
votes
1 answer
Summing a column value with each row value in excel
I want to add a column value with each row value in an excel. I would insert an image of my spreadsheet but apparently I need 10 reputation to do that.
Basically, it would be the following:
Cell B2 = B1+A2
Cell B3 = B1+A3
Cell B4 = B1+A4
and so…
ABZ
- 15
- 5
0
votes
1 answer
How to compile data from several workbooks in excel 2011
I am trying to copy a line of data from several workbooks in a folder and paste them into a master workbook (in the same folder) using VBA for Excel 2011 Mac. I have the following code but continually run into a Runtime error 1004.
After debugging…
0
votes
1 answer
Returning the kth of multiple matches
In Excel for Mac 2011, I am trying to create a table (in columns D-G) that references the data in A1:B5. I want E1 to search column A and report the data in column B corresponding to the first match; F1 to search column A and report the second…
0
votes
1 answer
FormatCurrency in Excel 2011
Below is some code I extracted from a Youtube tutorial using Excel 2010. When I try to run this on Excel 2011 for the Mac, the currency outputs are all integers. Does FormatCurrency() work differently in this version of Excel? Or have I just…
Tony Lima
- 65
- 1
- 9
0
votes
1 answer
How to hide or show a rectangle based on a variable
I hope someone can help, the title says it all really but here's the in depth bit.
Running Excel 2011 on Mac
I would like to know how I can hide or show a rectangle based on the variable for example
I have a variable in a1 that is a simple case of a…
0
votes
1 answer
Is there a way to access and evaluate Excel formatting codes via VBA
I am trying to write a VB script in Excel to parse some data in an Excel cell. To parse the data correctly, I need to utilize the formatting in the cell. For example, the text to be parsed below should be parsed as follows: a. MINESHAFT B. DARNLEY…
Mutuelinvestor
- 3,384
- 10
- 44
- 75
0
votes
1 answer
Method 'View' of object 'Window' failed with xlPageBreakPreview
I have a macro in which ActiveWindow.View = xlNormalView works well. However, ActiveWindow.View = xlPageBreakPreview returns an error Run-time error '1004': Method 'View' of object 'Window' failed.
Does anyone know what's wrong with that?
PS: the…
SoftTimur
- 5,630
- 38
- 140
- 292
0
votes
1 answer
Check box general selector and macro to show next three rows when one checkbox is selected
I am new to macros so I'm not sure this is possible in VBA.
I am trying to create a document where is composed with many mini tables made of 4 rows.
One row is the title which have a checkbox and will always be shown and three rows below where…
Amra
- 24,780
- 27
- 82
- 92
0
votes
2 answers
Macro to clear (a large number of) cells whose values are >1?
Is it possible to clear a large number of cells based on a value, i.e. if >1? I am using Excel for Mac 2011.
I would like to convert thousands of values >1 to empty cells in a large dataset (600 rows x 450K). The values are supposed to range from 0…
0
votes
2 answers
sort two columns on excel while keeping blank cells
So I trying to sort a list of names that have favorite colors to each of those names. In other words I want to have the sort look like the following example: (A and B correspond columns while #'s correspond rows)
**A** **B** …
thatonechin
- 13
- 2
- 4
0
votes
1 answer
Adding a space in excel text
I have a list of ID's (e.g. BSAR1, BSAR2).How can I easily add in a space after each BSAR automatically.
Is there a tool/function?
user3234810
- 482
- 2
- 5
- 18
0
votes
1 answer
Date Format issue with Excel for MAC
I'm trying to make the following code for mac, but it doesn't works(in windows this code works fine)... I'm originally programming this code in windows, for windows users, but now we have a new co-worker with mac, and that code is the only one with…
blackzero
- 49
- 4
0
votes
2 answers
Dynamic Cell Address in a particular cell
I have a query.
Can i get a cell id of the active cell in excel.
Suppose my current active cell by cursor is A6 , in some particlar cell , say A1 it should say A6.
Next time when i keep cursor on A10, value in the above particular cell A1 should…
0
votes
3 answers
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 formula which should calculate: if B3 exceeds 1500, i want it to display the difference.
E.g. IF value of B3 is 1600, C3 should display 100.
Thanks, can't…
Ray
- 37
- 1
- 1
- 7