Tagged Questions
0
votes
1answer
20 views
Checking for condition before continuing on a form
I am using Excel 2011 for Mac. I have a userform that contains 3 combo boxes. The data in the combo boxes is populated with information from the spreadsheet. The initialization populates the combo ...
2
votes
1answer
74 views
VBA Excel query a closed workbook without opening it
I'm having trouble searching for a string within a column of another, CLOSED excel workbook.
The following code gives a type mismatch error on MsgBox
If, however, I replace that line with ret = "'" ...
0
votes
1answer
40 views
Conditional copy/paste cells from sheet to sheet based on overlapping content in A columns?
Excel 2011, Mac.
Two sheets, both with names in "last, first" descending in A.
The name list of sheet 1 is much shorter than the name list on sheet 2.
Sheet 2 has the headings there in row 1, but the ...
0
votes
1answer
59 views
IF LOOP in VBA Function
I made two excel sheet.
one contains information as below
Date Name Quantity
12/7/2013 Bharat Sapte 12
12/7/2013 Ghorpade 10
14/7/2013 Desmukh ...
8
votes
2answers
607 views
How to develop an Excel Macro that contains regular expressions so it will work in Windows and Mac
I have developed an Excel 2010 VBA Macro that makes use of VBScript.RegExp. One of my users is apparently using Excel Mac 2011, which supports VBA, but no VBScript.RegExp.
I have seen several posts ...
1
vote
1answer
41 views
Looping the cells and getting the count of a string value in all the sheets and printing the count sequence in another column in respective sheet
I stuck with a problem in excel, also new to VBA macro.
I have 4 sheets (sheet 1, Sheet 2, Sheet 3, Sheet 4) in a excel file which consists of same two columns in all the Sheets. Columns namely ...
1
vote
1answer
10k views
Excel-VBA: How to get size of selected array in vba code?
i'm writing an vba function in excel which takes in an odd sized empty square matrix and filling it with numbers. However, I can't get to retrieve the size of the array that it dynamically selected in ...
3
votes
2answers
132 views
Excel contains filter with more than 2 values
Does anyone know how I can quickly hide/remove all rows in sheet1 that contain any of the rows info from sheet2?
It would need to contains filter as it wouldn't be an exact match.
For example
...
0
votes
3answers
131 views
Excel macro to find duplicates and copy their adjacent cells
I need a macro that loops column C and locates the duplicate values and copies them to col D, once a duplicate value is located it would copy the adjacent value from Col A and place it in Col E
...
1
vote
1answer
118 views
Mac Excel 2011 VBA UDF not working - SET or FIND command seems to be the issue
I am converting a spreadsheet from Excel 2007 to Mac Excel 2011. I have tried for hours to solve my problem, without success, so any help would be appreciated!
This UDF finds a string in a range, ...
1
vote
1answer
63 views
getelementsbyID inner dt id values
I am extracting data from HTML using Vb Script. This is the HTML code from which am trying to extract the data.
<dl id="overview">
<dt id="overview-summary-current-title" ...
1
vote
1answer
87 views
Mac Excel 2011 VBA Evaluate
I am moving a excel VBA from PC to Mac and one line has an Evaluate function, for example:
Public Function test()
test = Evaluate("=2+2")
End Function
However, if I try and run the macro on ...
0
votes
1answer
5k views
Macro to prompt user to select CSV files for import into existing sheet in workbook
I am running a macro which automatically takes csv files and import them into specific worksheets in my workbook. However, I would want to add greater flexibility by having the user select the files ...
2
votes
1answer
141 views
Excel for Mac 2011: UBound() Not Working
I'm working on making an existing macro-enabled spreadsheet functional on Excel for Mac 2011.
I have a function (Source) that searches arrays for a specified value:
Function ...
2
votes
2answers
317 views
How to edit Excel 2011 VBA buttons instead of clicking them
When I click the VBA buttons in Excel 2007 I go to edit mode. But when I'm trying to modify them inExcel 2011 - I click it, and it clicks! But how to switch command mode and edit mode?
