Tagged Questions
1
vote
1answer
34 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
8k 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
126 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
86 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
97 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
56 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
80 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
114 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
210 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?
4
votes
1answer
175 views
Copy-paste doesn't trigger worksheet_change
Here is what I need to do: When I have written something into a cell in the sheet, my Worksheet_Change code should check if the cell contains certain characters and then replace those characters. That ...
0
votes
0answers
72 views
Excel VBA with given values compare recordset obtained from Access
I have an input called part number i.e. Test123, and have obtained several datasets from an Access Database through vba.
Given data set in obtained order is:
(PartNo) (JobNumber)
TestW ...
0
votes
0answers
94 views
Ouput data to specific cells in Excel document through its vba from an Access database
Screen Shots of Access and Excel as Explained below (Visual Aid)
I am trying to obtain data stored in an Access Database and output it to specific cells in an Excel (Macro enabled template) document. ...
0
votes
1answer
73 views
Recursive list/sort with a redundant or missing cell
I'm using a single column of data that contains a few quirks. I have included the VBA code below the details of my problem.
An example of how the data is organized:
NAME
Court
Offe
Court
Offe
Offe
...
0
votes
0answers
525 views
VBA Code to update all Excel pivot table filters does not work on a Mac
I've created a set of pivot tables in MS Excel 2007 - all of the pivot tables are derived from the same data table. I have VBA code on each worksheet that will update all pivot table filters with the ...
