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. ...
1
vote
1answer
13 views

Excel VBA Sending emails with multiple attachements

So we are holding this big event and I have an excel sheet with everyones name, email address as well as their itinerary files (there are 2 of them) Cells(x, 3) and Cells(x, 4). What I am trying to do ...
-3
votes
0answers
24 views

Updating VBA code for Excel to find number of Google Search results

I need an Excel macro that can take a list of text items in column 'A' and return the number of Google Search Results for each item in column 'B'. I found a code on another question on here that ...
-1
votes
0answers
21 views

Excel vba programming - How to use a command button to find values in another workbook

I am very new at vba programming so I might have a very basic question. I have a workbook where I am making a pie-diagram over how much money that is used on different parts. This is just for, let say ...
0
votes
2answers
17 views

Macro Select all for Pivot tables

I am trying to make a macro for creating a pivot table. I need the Macro to select all of the data on the sheet; a friend of mine has helped me create the code above, however the macro only selects ...
0
votes
0answers
20 views

Search with 2 values in 2 different columns

I have 2 search cells B2 and B3. And I want them to find and write data from a sheet called fakturor. I works fine with one one B2 to search in column B in sheet fakturor. But if i want that both ...
0
votes
0answers
6 views

Auto outlook mail to be sent to the receivers given in Excel sheet based on the condition

I am new to this forum & I just started to learn Macro. I need to write Macro for the below requirement. Pls refer the below image for an example. Column B is having the contract details (AMC), ...
0
votes
3answers
19 views

Excel VBA: Copying ranges from one sheet to another using variable cell references

I am trying to copy one range to another via vba in excel, however it refuses to copy anything. This is my code: Worksheets("SEARCH SHEET").Range(Cells(destination_y, 1), Cells(destination_y, ...
0
votes
1answer
16 views

VBA Code not recognizing dates in certain format

I am working on a code that uses a unique ID number and associate date to see if a same record already exists in the worksheet. Here is my code: Part of first code: Else 'If all the data has ...
1
vote
1answer
16 views

VBA Delete Empty Cells with Multiple Column Selection

I am having a small amount of trouble with finding a possible solution to a potential problem of mine. I am writing a macro for my supervisor using VBA so that she can just click a button assigned to ...
0
votes
0answers
9 views

excel 2010: change pivot source data WITHOUT disconnecting slicers

i've created an excel template which has multiple pivottables on multiple sheets which are all linked to 1 datasource. I also have 4 slicers connected to numerous pivots. Now someone adviced me to ...
-5
votes
1answer
43 views

VBA helped regarding this Q

Sub CalcTotalPerClass() Dim Yes As Boolean Dim No As Boolean Range("B5").Select ActiveCell.Value = WorksheetFunction.SumIf(Range("ClassEnrollment1!A5:A44"), 2, _ Range("ClassEnrollment1!D5:D44")) ...
1
vote
0answers
23 views

Using Luacom to change cell borders in excel

I have a range of cells in excel and i need to ensure that all borders are shown. So far i have: oExcel = luacom.GetObject("Excel.Application"); Book = oExcel.Workbooks:Open(_DesktopFolder .. ...
0
votes
1answer
28 views

VBA Macro to extract strings from word doc

i have a word document containing several strings. These strings have the first part always the same, for example ABC_001, ABC_002, ABC_003. I need to search for "ABC_" substring in the doc, extract ...
1
vote
1answer
33 views

Killing connection in EXCEL vba

I am trying to removeconnection from my work book but I am still geting run-time error 5. I dont know what to do because in my other projects it works. Thanks for advice. Greeting from czech ...
2
votes
2answers
17 views

vba excel error “by ref argument type mismatch” when passing key to function as string argument

I'm getting an "by ref argument type mismatch" error on the following sub test(): Public Function GetOtherDict(k As String, dict As Dictionary) As Dictionary Dim otherDict As New Dictionary ...
0
votes
0answers
21 views

VBA Chart From Pivot Table

Dear Fine People of Stack, I have previously asked for help from the community and the community came through. In the span of a few moments I learned more at one time than I have in my classroom all ...
0
votes
2answers
31 views

Sub arrays in VBA - I want to slice a dimension off

Say I have a 2D array, dim iArray(1 to 2, 1 to 2) as integer iArray(1,1)=1: iArray(1,2)=2: iArray(2,1)=3: iArray(2,2)=4 'iArray = 1 2 ' 3 4 and I want to cut one of the dimensions ...
0
votes
1answer
22 views

Add a chart on excel with vba

I'm trying to add a Scatter chart on a sheet, when I doit manually it works just fine, but when I try to use the recorded macro it give me an 1004 error on " Sheets("Mapa ...
0
votes
1answer
26 views

Autofill Application.Countifs.Formula VBA Excel

I think this might be a simple question but I can't seem to find a way to autofill an Application.WorksheetFunction.SumProduct(wsf.CountIf formula so that the row number would change as the formula ...
0
votes
1answer
19 views

Select rows specified in inpubox and select specified columns [on hold]

I'm a VBA newbie and I would really appreciate it if someone would help. I would like to create an Excel VBA makro, which does the following: It shows a box, where I need to type a starting cell ...
0
votes
1answer
43 views

Excel 2011 - Pulling data from multiple workbooks

I have a series of project models (all different workbooks) which contains deals that we have sold. The model itself are in two half's, top is costs and bottom is revenue. Along the rows are the names ...
0
votes
0answers
24 views

VBA filtering using dates and forms

I want to let my users filter some data using 4 criterias that they input in a form. Based on what the filter finds some further processing will be done on these data. Criteria are: start date end ...
0
votes
1answer
26 views

combobox dropbox in VBA issue

I have issue with combobox.DropDown method when use it in change event will show only 1 result with scrollbar to show the other results . Private Sub emp_name_Change() Call Connect_to_db ...
1
vote
1answer
20 views

Userform Object Values - Help Needed

I am struggling with an issue regarding a userform and I would appreciate your help. Basically I have the following problem. I have created a Userform (manually in the VBA Projectbrowser). I have ...
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
0answers
44 views

If the cells in one row equal then insert row below and average the numbers in anther string of cells

I need to compare cells H and if the numbers in Cells H equal insert a new row then average the cells in J-GS. I am also trying to get it to highlight the ones with multiple one color and the cells ...
0
votes
2answers
30 views

Excel/VBA - Error1004 Doing a Cycle with GoalSeek

When I run this code I manage to fill the table that I want to, but in the last iteration it breaks on the Range("F" & r)... line and gives the error1004. I don't see why. Indeed running it ...
0
votes
1answer
44 views

Excel Macro Button not displaying correct data

I have one button macro for reading data from excel files after leaving some(irrelevent starting rows of detail) rows(A1-A10) and merging all those files in single file. It runs correctly when i use ...
1
vote
2answers
34 views

How to format Date & Time in VBA?

I have a userform to display excel worksheet named "results" using OWC Spreadsheet 11.0. The steps could be found from this link : display a part of an excel sheet on a userform using vba Now i ...
0
votes
2answers
44 views

Condense Table using VBA

I am really new to VBA, as I usually do most of my Excel/Access manipulation using SQL or MATLAB. (In fact, I've already solved the below problem in MATLAB) I'm trying to pull a table, representative ...
0
votes
2answers
35 views

copying and pasting into another cell

we are trying to go through a range of cells looking for a particular string. In one case the string is accessibility but the whole string is accessibility3.2. Then we want to paste the string to a ...
0
votes
1answer
20 views

Incorrect Syntax Near GO in ADODB Connection for Excel

I'm trying to pull data from a SQLServer database with a stored proc directly into and excel spreadsheet. I'm trying to make a dashboard that will allow the user to make a selection for the specific ...
1
vote
1answer
23 views

Selecting the first to last column of data when using a macro to graph data in Excel vba

I am compiling a bunch of data from some tests ran at work, and I want to have a macro select data from the first column all the way to the last column on the sheet. The problem is that the amount of ...
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
19 views

Excel VBA - Bypass WinHTTPRequest Timeout

I'm running several WinHttpRequests in VBA, and I would like to make the program simply avoid throwing an error and move on if one of them times out. Is there any way to make that happen?
2
votes
1answer
29 views

Excel formula or VBA code searching column for a list of items and eliminating double counts

I am new to VBA and I couldn't find a built in formula in Excel to return exactly what I'm looking for. I am search a column AN (AN1:AN80627) which is an item description, so it is a sentance. I have ...
0
votes
2answers
42 views

Excel Header Macro maxes out at 3 lines

This macro is to set a four line left header for all the worksheets in the workbook. The point of this macro is to have control of each line's font size, and attribute i.e bold. I have a separate ...
1
vote
3answers
47 views

wsf.CountIfs Array Debacle - VBA Excel

I'm facing a bit of a strange problem that I can't quite explain. I'm using Worksheet function along with the CountIfs formula, and I also use Sumproduct in order to use Arrays. However, everytime I ...
0
votes
1answer
42 views

Pulling Information from Access into Excel

So currently I have code to pull a whole entire table worth of information from Access into Excel using Excel VBA. Is there a way that I can run a query in Excel VBA for Access and then just Pull they ...
0
votes
0answers
31 views

Layered Sentiment Analysis

Suppose I have a several lists of unigrams and bigrams, respectively. These lists are in Excel and can be used to analyze the sentiment of some strings of text. Is there a way to have Excel match ...
0
votes
0answers
27 views

Word List Search Ambiguity

Suppose I have a list of words in Excel and I want to match these words to strings of text I find at random from a single page. Is there a way to make it so that even if the words pulled from the ...
0
votes
1answer
56 views

Issue with calling a procedure from within Workbook_SheetChange

I created a workbook with multiple sheets requiring numerous two-way linked cells in different worksheets within the same workbook. So, if I edit cell B5 in worksheetA, it will automatically update ...
0
votes
2answers
54 views

Excel 2010 vba copy select sheets, save and close both workbooks

I have a workbook that creates 3 logs. Before close I need those three sheets to copy into a new workbook then I need both workbooks to save and close themselves. I've gotten as far as the code below ...
0
votes
1answer
69 views

Divide rows and then transfer divided values in new worksheet (values: time periods & amounts)

Hope you can help with this: In worksheet "TOTALS" and Range "M11:N251" there are "from:to" time periods inserted by user ("From" is in "M11:M" and "To" is in "N11:N"). Number of rows (and inserted ...
0
votes
1answer
25 views

Update form with events

I have an UserForm (frmProgress) which should display the progress of the process with a label. In a class module (clsProgressForm) I create the UserForm as follows: Option Explicit Public Event ...
2
votes
2answers
32 views

Referring to newly added worksheets

I want to refer to newly added sheets. They are added by a loop. They are named Sheet1, Sheet2, Sheet3 etc. I also have a variable n which equals to 1 when a Sheet1 is created, equals to 2 when a ...
1
vote
1answer
18 views

Populating a column from few textboxes (VBA)

I need help with a VBA script. Our teacher has told us to use: ListBox1.AddItem ComboBox1.Text And Val(TextBox4.text) And ListBox1.AddItem FormatCurrency(price, 2) It is supposed to show both the ...
1
vote
1answer
42 views

EXCEL VBA Sort after Populating Data

I am new to VBA, and excel macros, but not basic programming. I have a few dozen excel files, that I am taking data from, cleaning it, and populating it into one file. After the data is populated, ...

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