Tagged Questions

0
votes
0answers
24 views

VBA for deleting duplicate rows but keeping the highest value [on hold]

Using Excel 10, I have 5 columns of data. A=Emp #, B=Emp Name, C=Title, D=Location, E=Rate. There are times where 1 Employee will have more than 1 rate causing them to show up twice on the report. ...
0
votes
0answers
18 views

Excel ODBC connection doesn't update all data

I have an Excel Workbook that has an SQL ODBC connection to a database. The data is supposed to update in an Excel Tabel. This works fine as long as I don't touch the results. However, while working ...
0
votes
0answers
27 views

insert code to pull only data that matches a specific date entered in a cell

Here is my code below that i need to edit. right now it pulls everything from 3 columns, Works great i need to take one step more and make it so it will only pull the data that matches a date i put in ...
2
votes
0answers
28 views

Extract/Alter/Delete data from copied sheets

Thanks guys. I need to copy & paste 2 sheets which have references to each other. I have found a way to group them and copy/paste both of them at the same time. However i have difficulties trying ...
0
votes
1answer
28 views

Quotations in Access String from Excel VBA

Ok I am having a Problem using VBA from Excel 2010 to Query data in access, the problem comes when the variable Descripcheck, or Grouplocal, some of the descriptions have a "" in the excel cell so ...
0
votes
0answers
16 views

VBA Is There a Way to Enable/Disable Mouse Clicks In Excel?

I'm building a complex dashboard in Excel 2010 where I have many pivot charts. I've added buttons and code to automatically jump to the specified chart or sheet. I've also added code to keep the user ...
0
votes
0answers
27 views

Excel VBA Run-time Error '32809' - Trying to Understand it

A colleague at work made some changes to one of our macro workbooks and now on my PC only I receive the dreaded Run-time Error '32809' when I attempt to run it. This latest version runs fine on his PC ...
0
votes
0answers
15 views

SQL Server Management Objects (SMO) Reference in Excel 2010 VBA Project?

Using Excel 2010 using VBA, I would like to be able to start/stop and view running SQL Server jobs, create new tables for import jobs, as well as run backups and other administrative tasks on my local ...
0
votes
0answers
25 views

Perl script is not working propely through VBA

i have a perl script. which will generate a text file as output. when i click on the perlscript i works smoothly and gives the output. But via VBA macro it is not giving output file. it just flash the ...
0
votes
0answers
50 views

Excel 2010 VBA, why does formula display as text?

Why would the recorded VBA display the calculated value. Whereas my code displays the only the formula (but if I go into each cell and hit f2, then return, it shows calculated value). I am using a ...
0
votes
3answers
26 views

CountIf does not work as expected when used multiple times in a function

Hello I am trying to run the following code to count the number of times something appears in a sheet. Sub test() ' passes in what sheet (Sheet1) to search and which row (5) to write the results ...
1
vote
2answers
62 views

Excel VBA select entire sheet using Range

I am using the following code to search through a sheet to find out how many times does the word 'example' appear. count = Application.WorksheetFunction.CountIf(Range("A1:A10"), "example") I can't ...
1
vote
3answers
39 views

Find and count the number of occurrences in a sheet

I need to find out how many times a sequence of numbers occurs in a sheet using VBA. For example: 201-1-55-8799 301-5-55-8799 202-1-55-8799 201-1-55-8799 999-5-55-8799 001-2-55-8799 I want to ...
-1
votes
0answers
38 views

Copying and paste cells value from one workbook to another (codes troubleshooting)

as i am new to vba, i tried to modify the codes but i can't seem to find the code to start new row after another. Now i am able to copy and paste cells values from one workbook to another but when i ...
1
vote
1answer
36 views

Excel Help Needed - Comparing Multiple Cells and Returning Values

I have a spreadsheet that looks like this: A B C D 1 Bob 10/02/2013 10 2 Bob 10/02/2013 2 3 Bob 10/02/2013 8 4 Steve 10/01/2013 6 5 Steve 10/01/2013 6 6 Sally 10/01/2013 6 ...
0
votes
1answer
56 views

Visual Basic for Excel2010 code error

I need help with getting two different Drop down menus to work. Each menu item requires a choice that gives an answer back in the form of an image. I can get the 1st menu to work but the second one ...
0
votes
1answer
29 views

Is there a way to disable the compatibility checker in Excel 2010?

I have a code to autosave in a new folder when I press a button; the code is working fine but the compatability checker comes up prior to allowing the save. Is there a way to disable this ...
0
votes
1answer
51 views

Load multiple workbooks(and filtering) into a same sheet excel 2010

i am trying to load multiple workbook into the same sheet, these workbooks will all contain one common column header. After i load multiple workbook, i would like to search for the rows i wanted and ...
0
votes
1answer
31 views

Search for specific name header column

How can I Search for specific name header column "DATA/HORA" and adapt to macro below? Sub Data() Dim cell As Range Dim lastRow As Long lastRow = Range("A" & Rows.Count).End(xlUp).Row For Each ...
2
votes
0answers
154 views

Oracle and ADO Query from Excel returns no results

I am having trouble running a query in Excel 2010 VBA code using Oracle OraOLEDB.Oracle Provider. Certain queries work fine and return results, while others return no results... I connect as such: ...
0
votes
0answers
19 views

Excel add-in macro failed to run on multiple workbooks

I created an excel add-in (xlam), and there is a macro within the addin (with keyboard shortcut key assigned) will open a workbook (source) and copy a value into a current active workbook ...
1
vote
1answer
47 views

How to make two buttons in Microsoft Excel sort a table upon click?

I have a spreadsheet with 5 columns (A-E). The first is "TEST YEAR", the second is "FORM", the third is "QUESTION, the fourth is "TAGS", and the fifth has no header title, but it still has data. At ...
1
vote
1answer
18 views

Published Excel macro fails to be recognized

I downloaded this macro to apply names to worksheets (worth noting that this page is also referenced in Microsoft's help pages somewhere). But when I try to run the macro, it's like it doesn't exist. ...
1
vote
2answers
216 views

Open an Excel file from SharePoint site using VBA

I'm trying to open an Excel file from a SharePoint using VBA. Because the file I'm looking for might be different each time I run the macro, I want to be able to view the SharePoint folder and select ...
0
votes
0answers
38 views

Wildcard search in excel 2010

i am trying to make a wildcard search in my programming, so far, i am able to search only a single column and i'm able to copy that searched row and paste it in my desired form, what's needed to add ...
-3
votes
0answers
20 views

Merging rows when have the same specific text (Excel)

I am using excel 2010, I get really tired with it, I'll appreciate any help. Current table 1000.5 ---1001--- limestone 1001----- 1002--- limestone 1002 -----1003--- limestone 1003 ...
4
votes
1answer
24 views

Stepping through macro code that is copy-pasted and executed using Run Application

This is my first time on this amazing forum. I am also very new to vba (3 weeks). I have 2 macros: CallerMac, WorkerMac. These are in separate modules within the "Modules" node of my VBAProject. In ...
0
votes
1answer
38 views

Macro to update blank cells based on the number of times a button is clicked and whether adjacent cells are filled or empty

I have an Excel spreadsheet for my warehouse which works like this. The EAN code is scanned through a barcode scanner in Column A The code for the product is vlookedup in Column B A dynamic pivot ...
1
vote
1answer
49 views

Excel VBA 2010 - worksheet.subtotal function sum and average in the same row

I am creating a macro which takes data from an Oracle database, which means that the number of rows can vary depending upon the result. In this macro, I am using the worksheet.subtotal function, which ...
1
vote
2answers
40 views

Value of a user defined function

I have an User Defined Function in Excel 2010 VBA. In a cell A1, I call that function: =myfunction() and the returned value (as Integer) is showed correctly in the A1 cell. My concern is how can I ...
0
votes
1answer
54 views

Cannot return many properties of PivotItem

This is baffling us. I have a standard pivot table with a report filter on it that allows multiple selection of items. I can get the selected items in the report filter with: Dim pi As PivotItem For ...
1
vote
1answer
26 views

Excel pop out application inputbox ( search function )

i am trying to create a pop out box to search for a certain value on the 2nd column, as i am still new to vba coding, i could only do this much through googling. What i'm trying to do was (all these ...
0
votes
1answer
53 views

Excel 2010 (xlsm) Forms Button sometimes disappeared

Has anyone come across the case when using a xlsm spreadsheet in Excel 2010, the Forms Button sometimes disappeared, but then sometimes it appears again. Obviously its a bug by Microsoft but any ...
2
votes
1answer
60 views

Application.EnableEvents = true every time returns false

I have opened my excel sheet and then opend the VBA editor.In the immediate window I execute the following command. ?Application.EnableEvents = True It returns False . But If I opened new excel ...
2
votes
1answer
68 views

cycle IF based on autofilter condition

I'm trying to solve a problem I'm actually stuck on due to my inexperience with Excel Macro. I'd like to build an IF cycle based on an Autofilter choice; in case of a positive feedback ("Magnet" ...
1
vote
2answers
96 views

MsgBox not big enough for text

I have a string (msg) that is pretty much a very long list of items. I need to put this in a msgbox but it is not long enough to show the whole text. Is there an alternative to this? Thank you!
0
votes
1answer
76 views

Deleting empty rows - MS Excel using VBA

I am using following VBA to delete all the rows that does not have * in Column T. It works but it only deletes 1 row at a time. I have to run the vba 25 times in order to delete 25 rows that does not ...
0
votes
4answers
62 views

Get last value of series in Excel?

I have my excel sheet like this: A | B ----- 0 | 2 0 | 3 0 | 4 0 | 5 0 | 6 0 | 7 1 | 8 1 | 9 1 | 10 1 | 11 1 | 12 2 | 13 2 | 14 ... How do I get the value of B for the last occurrence of each ...
0
votes
2answers
52 views

Excel VBA: Why can't I get a range from a worksheet I passed into a function?

I'm trying to use a helper function to get a range to store it into a variant, but I'm running into some issues. At first, I just simply tried the following: Function GetRange(RangeLetter As String, ...
0
votes
3answers
91 views

excel if true then a and b and c

I am using MS Excel 2010 want what to change a number of cells if a value is true e.g. a2 =2, b2=1, c2=$30, d2=10 A B C D 1 Prz Stat Val Pts 2 2 1 $30 ...
0
votes
3answers
61 views

Textbox and cell linking

I'm using Office 2010. I am writing a VBA macro in Excel where I want a text box (say TextBox 2) to have a value equal to the value of a cell. The cell is not known beforehand. I used the following ...
0
votes
1answer
25 views

Print dynamic list in pop up

I have a list of dynamic length from columns A to F. (starts at row 1) I need to make a code to have this list printed on a pop up. I don not want it printed on another sheet, the sheet this list is ...
0
votes
1answer
77 views

excel VBA code not working

I have a excel sheet with a VBA code as follows Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 1 And Target.Column = 5 Then Dim iRet As Integer If Not ...
-1
votes
1answer
90 views

Excel 2010 VBA/MACRO lookup field value to auto create statement

I need a macro/vba which can auto create a select stamen based on the value in the excel. Example as below. The query can hardcode as 'SELECT * FROM PRDTBL WHERE' the remaining part should handle by ...
0
votes
1answer
61 views

Distinct Values in OLAP Cube Pivot Table

I regularly interact with massive OLAP based Pivot Tables. Usually these are more or less undocumented. And thus they are difficult to really wrap my head around and use effectively. One of my ...
0
votes
1answer
103 views

Insert or Delete column if does not equal heading

I have column headings starting in Column L going forward. The column headings need to be in a certain order. By hand, I have to insert columns so everything is in order. I put insert or delete in ...
1
vote
0answers
60 views

excel issue - calculating formulas are not happening automatically

I am using Microsoft excel 2010. Values are getting downloaded from database and I am writing them on to excel. I have some formulas written in excel itself. So, my formulas would be using the values ...
0
votes
1answer
53 views

Split values in a dropdown list and display on a spreadsheet

I have a excell sheet with a drop down list. The values are some comma separated values. For example XXS, XS, S, M, L, XL, XXL, XXXL 2/3, 4/5, 6/7, 8/9, 10/11, 12/13 1-2, 2-3, 3-4, 4-5, 5-6, 6-7, ...
0
votes
0answers
144 views

Excel VBA: Auto populating a sheet with data from other sheets as values by selecting from a dropdown list

I need some help with coming up with some code and this is my first foray into excel's VBA stuff. Here is my problem: I have four sheets in my workbook (let's call them "LA", "Miami", "Philly", "New ...
0
votes
1answer
144 views

Excel 2010 Chart axis not shown up

I am converting a EXCEL 2003 application to EXCEL 2010. Data are shown up fine but the axis does not show any more. which function to show the axis with automatic scale? For Example: If you plot ...

1 2 3 4 5 … 15
15 30 50 per page