Tagged Questions

1
vote
1answer
11 views

VBA to merge cells in excel

I have a excel sheet like below. Consider the sno column as Excel numbering. So all the columns except DateTime are merged. I want to Merge the DateTime cells and want to delete the empty records. I ...
0
votes
2answers
16 views

Applying multiple conditions to formula

I have a situation where I need to apply several "value boundaries" to several different "starting positions" and then subsequently output the "ongoing position". The "value boundaries" are: <500, ...
0
votes
2answers
28 views

Nested IF statement

The following is something I have tried after some research on nested IF's however it only gives expected results for the first part of the statement and not the remainder, can anyone explain why or ...
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 ...
0
votes
0answers
17 views

Excel combining and grouping

I have a spreadsheet that contains multiple columns of data that can have duplicates. In the last column is the name that is attributed to the previous columns. I have been looking and trying to see ...
-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, ...
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
2answers
19 views

Expanding sheet rows and appending information of another sheet in accordance with a common column

I am trying to unify the information present in two different sheets by expanding the number of rows of the first one in accordance with a column present in both sheets (project name). Suppose my ...
-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 .. ...
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 ...
0
votes
2answers
17 views

Macros: Recorded Macro not working

I have recorded a macro in excel using Record Macro option. However, when I run it, I get the Error 438 and the error box displays Object does not support property or method. Here is the generated ...
-1
votes
0answers
19 views

Determine first column and row with actual data in excel by vba [on hold]

How to modify below code to determine first column with data ? Sub LastUsedColumn_Find() Dim lastColumn As Integer Dim rng As Range Set rng = ActiveSheet.Cells lastColumn = rng.Find(What:="*", ...
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 ...
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 ...
2
votes
1answer
22 views

Excel – Generating Word document using VB Script

I have a bunch of VB script in Excel that ultimately opens up a new Word document and places a bunch of information in it. Everything works well, but I am having one annoyance. The annoyance is that ...
3
votes
2answers
31 views

Using Target to Recognize a Cell Location

I run into this issue a fair amount and am curious if someone can tell me why or how I can write this a little cleaner. Below is my code and it does work. If Target.Row = rTime.Offset(0, 1).Row Then ...
-1
votes
0answers
9 views

MS Excel Web browser object [on hold]

I have installed browser object in MS-Excel (2007) using developer tool (webbrowser object) without any problem but my requirements are a) on click of the link like http://google.com link should ...
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 ...
1
vote
2answers
30 views

Function doest work when form embedded in excel sheet

Would like to ask expert here, why the below code doesn't work in excel sheet ? This code is covert an excel file to text file based on user selection, the selection can be export full excel sheet or ...
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
2answers
36 views

Determine if any cells in a column range equal to 0, final result is 0, or else is 2

Sorry if my title is confusing. I'm new to Logical formula in excel but I need it to achieve something now. I had check the internet for the formula but found it abit confusing and not sure what ...
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 ...
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
23 views

Excel Macro Issue, Data Column Separation

I am having an issue with the format of data in excel coming from another system. The data does not separate into columns but rather becomes indented in a single column. See example below. Country ...
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 ...
-1
votes
2answers
61 views

Covert column letter to number

found below code from Google which can convert number to column letter, but how about from column letter to number, anyone can help rewrite the function ? Thanks Sub colLtr() Dim mycolumn mycolumn = ...
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
29 views

Hidden data in excel

I would like to know how can we get the hidden data about the excel workbook programmatically e.g. which cell value is hidden, hidden row, hidden column, hidden sheet etc etc? how this data is stored ...
-1
votes
1answer
20 views

Compare string value in excel vba

How to compare string value in excel vba ? for example texbox1.text = A and textbox2.text = AAA, so texbox1.text < textbox2.text therefore msgbox will display A < AAA. how to achieve this ?
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
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 ...
-2
votes
0answers
17 views

Excel - return each value in column, depending on row [on hold]

I'm trying to turn this: Name Value Bob B510 Bob C620 Bob M123 John F658 Mike E987 Mike G596 Into this: Name Value1 Value2 Value3 Bob B510 C620 M123 John F658 ...
0
votes
1answer
19 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 ...
0
votes
2answers
44 views

Macro 101: Beginner advise [on hold]

Where can I find basic terminology on macros, and basic formulas? Without buying a book? I have been looking online a lot and I cant find a macro dictionary or anything of the sort. basic stuff like ...
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 ...
1
vote
0answers
20 views

VBA (Excel) Dictionary on Mac?

I have an Excel VBA project that makes heavy use of Windows Scripting Dictionary objects. I recently had a user attempt to use it on a Mac and received the following error: Compile Error: Can't find ...
0
votes
0answers
10 views

searching a database based on input values and output results

I am working on a search tool that takes in certain electrical parameters and then searches through a database of information that I have entered about specific parts. The desired result would be to ...
0
votes
0answers
27 views

Populate a drop down menu using check boxes in excel

I'm doing a semi-complicated operation in an Excel spreadsheet. I have two spreadsheets in a workbook. The first spreadsheet has several checkboxes that are categories that are listed in the second ...

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