current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0

Tagged Questions

1
vote
1answer
26 views

Is it possible to insert text boxes/labels into a chart using vba?

I'm currently writing a program that will graph an x-ray spectrum, and then calculate where all of the peaks are, and what they should be labeled. However, I'm not sure how I can add the labels of ...
0
votes
0answers
37 views

VBA Type mismatch when deleting a row

Using Excel 2010, VBA purpose is to move rows which are marked as 'complete' in column H into a different worksheet (before this, it stamps them with a complete date etc). I'm using the ...
2
votes
2answers
62 views

VBA Excel Finding and Combining Rows Based on Matching Column Cells

I'm trying to figure out a way to combine rows based on values in two specific columns in vba excel. For Example: Let's say I have the following sheet: Column A Column J Column Z 1 A ...
0
votes
1answer
48 views

FileSystemObject FileExists works on one computer but not another

In Excel 2010 VBA, I'm using the FileExists property of the FileSystemObject to check whether a file exists. On my computer it works fine. But on another Excel 2010 computer, it reports that the file ...
0
votes
2answers
33 views

How do I add a User Defined Function to Excel?

I have a simple stored procedure that returns a Description and a Name when you give it a ID. I need to enable this inline in multiple Excel Sheets. Something like =ItemLookup('12345') that would ...
1
vote
1answer
33 views

Value used in formula of wrong data type

I have been trying to figure this error out for the past few days with no luck. I am hoping one of you would be able to help. I am getting "value used in formula of wrong data type. Quick ...
2
votes
1answer
64 views

Application-Defined or Object-Defined Error Excel

I have this sub in Excel 2010 that’s supposed to do the following: ·         Take the value in (6, 4) in Sheet1(Form) and find this value in Sheet7’s (Dates) column 1 ·         Find the row in which ...
1
vote
1answer
18 views

excel vba not exporting pagesetup to pdf correctly

I have code which formats a worksheet to the desired setup and layout (one page wide and tall in landscape). When I run the code (part of a long macro) it formats the pagesetup correctly. If I ...
1
vote
1answer
38 views

Could Not Find Installable ISAM Excel 2010

I have this sub in Excel 2010 that's supposed to copy in a table from Access 2010. When I try to run the code, it gives me a 'Could not find installable ISAM'. When I debug, it highlights ...
2
votes
2answers
59 views

Compare Value and Transfer Column in Excel 2010

I have this sub in Excel 2010 that transfers columns from other sheets and inserts it into a table. The new table has 7 columns. The first 5 are just copying right from the other sheets and they work ...
0
votes
0answers
28 views

Modifying the scale of a chart's axes

I'm creating a program that will allow the user to change the scale on the axes of a chart by inserting values into certain cells, and then pressing a button. This will allow them to easily zoom in on ...
2
votes
1answer
25 views

Creating a chart in VBA using the Cells method — Application or Object Defined Error

I'm attempting to create a chart using VBA in Excel 2010. I'm attempting to select data from another sheet in the same workbook. The data, however, is horizontal (and has to be kept that way), so I ...
0
votes
2answers
52 views

for loop to extract month from data

I have around 4000 rows of dates I need to extract the month (number) from. I know you can do this with a formula (Month(date)) I have beat my head against this keyboard and have finally given up. ...
0
votes
0answers
20 views

Excel VBA File not Found right after Excel listed the file from directory [duplicate]

I have written a VBA Programm that searches for certain Excel Files in a directory that the user has chosen. This produces a list of files, each of which is afterwards openend, some data copied and ...
0
votes
1answer
34 views

How do I check if a button exists if I don't know the name?

Is there a way to see if a button exists on a worksheet if I don't know the name? I have code in "ThisWorkbook" that creates a button when the workbook is opened. However, I don't want it to create a ...
-3
votes
1answer
34 views

copying workbooks from current folder and also subfolders

This is part of the sub I found to copy all tabs in all workbooks in a directory to my current workbook, but how can I adjust it to scan all subfolders as well? Currently, it only copies from the ...
0
votes
1answer
23 views

Excel // Dynamic Range in Sum If Function

I’m trying to have a quite complicated Sum if function more reliable. The situation is that I’m using that formula (see below) to sum values between two dates from a separate sheet in the workbook. ...
0
votes
1answer
37 views

Copy tables from access into excel spreadsheets

I have an excel 2010 workbook, Verification Form, that I need to copy tables from Access 2010 into so that I can populate a form. I have three access tables – Dates, Activity, and Projects – and five ...
1
vote
0answers
29 views

Corrupt Excel File After Removing XML Nodes

Backstory I'm attempting to use VBA to delete several nodes from an Excel sheet XML file. The nodes correspond to filtering done on a sheet in the workbook, and I'm trying to remove the filtering. ...
0
votes
0answers
22 views

Update Data in Excel File From Different Excel File Using SQL

I have two Excel files, a master file and a regular file. Both files have a sheet with the same data structure (same fields, but not formatted as tables). What I'm trying to do is use VBA to create ...
0
votes
3answers
44 views

Excel Cell Parsing

I have two columns of about 4,000 cells of data each. I need to format each column in a similar way. Column 1: Scenerio 1: Each cell has data that begins with "qwe". If there is a "bc" after the ...
1
vote
1answer
46 views

How to change case of method name in VBA?

While learning VBA I did a lot of copy-paste of code from the internet. At some point I have noticed that whenever I use a method which name is "Add", the VBA IDE automatically change it to "add". For ...
0
votes
1answer
20 views

Modify Z-index on Series object in Excel 2010

I am using excel 2010. I have a chart diagram on which i put a rectangle to surround the highest column bar. In order to make things more readable, i would like to place this rectangle on the chart ...
0
votes
1answer
19 views

Number to be copied from cell with the same number format and show it as a label for a shape without any change in the number format

I have a cell in excel which contains a value, lets say 100000. Now i want this value to have commas in between them to represent the thousands and millions i.e. 100,000. I can do this by changing the ...
0
votes
1answer
30 views

Break connections in excel while keeping values in cells

I have an excel workbook which has 5 worksheets. The back 4 worksheets are filled from queries in Access with values for a summary. The front worksheet is formated all nicely and has graphs and such. ...
0
votes
1answer
41 views

If dropdown value is selected add formatting and values to cells to the right

Ok so I am making a sheet where a user would select a value from a dropdown and then needs to see the required parameters based on the selection. Example: If i select X from the drop down then three ...
0
votes
2answers
27 views

Open field in protected, shared Excel workbook

I have a shared, protected workbook that has a button to bring up a search form. There are two fields on this form, txtYear and cbxRegion, that I need enabled. Whenever I try to open the fields, it ...
-1
votes
1answer
29 views

Building a Vlookup between separate workbooks

I am new to VBA coding and am attempting to build a Vlookup to connect two seperate workbooks. Provided belwo is my coding which is currently producing a Run-Time 1004 Method 'Range' of ...
0
votes
2answers
26 views

Not able to run vba automatically while selecting value from list box

I have made a list box using data validation and put values inside as 1,2. And my expectation is that whenever I select 1 from the list box the rows from 4 to 8 should hide and when I select 2 it ...
-1
votes
1answer
45 views

Excel 2010: Subscript out of range error

The error that I am receiving is Run-time error '9': Subscript out of range. Sub Workbook_Open() 'Turn off any alerts that maybe displayed. Application.DisplayAlerts = False 'Turn of the screen ...
1
vote
2answers
28 views

Run code EXCEPT when new rows are added to the table

I have a little piece of code that monitors cells in the 'Y' column for changes and if there is a change then the main bit of code runs. Is it possible to run the code as usual EXCEPT when a new row ...
0
votes
0answers
16 views

Move onto next image object is no matching JPEG found

Using the code below. If one of the images are not found, how can I loop over it? At the moment, when one image isn't found, it places the next image in the placeholder of the one it should have ...
0
votes
1answer
38 views

Removing special characters VBA Excel

I'm using VBA to read some TITLES and then copy that information to a powerpoint presentation. My Problem is, that the TITLES have special characters, but Image files that I am also coping over do ...
1
vote
2answers
73 views

Non-volatile UDF always recalculating

I am trying to make a non-volatile UDF but it seems not possible. So here is a my very simple test-UDF: Option Explicit Dim i As Integer Sub Main() i = 0 [A1] = "zyy" MsgBox i End Sub Function ...
0
votes
1answer
24 views

Automatically update PivotTable data source

Using the ole' search that stackoverflow provides, i found the following code Sub Change_Pivot_Source() Dim pt As PivotTable For Each pt In ActiveWorkbook.Worksheets("Funnel Data ...
2
votes
1answer
32 views

Setting the convergence value to a variable for the built-in solver

In creating a program that uses the solver, I need the user to be able to manually input a value for the convergence and the precision that the built-in solver uses. I'd love to be able to set the ...
0
votes
3answers
34 views

VBA Named Range dropping Sheet reference

I have a named range called "MyRange." It's define as ='Sheet1'!$A:$A. In VBA, I have the formula LastRow= Cells(Rows.Count, Range("MyRange").Column).End(xlUp).Row. It should return the last row with ...
0
votes
1answer
47 views

Search for a value in multiple columns and copy the entire row if found

My master worksheet (SHEET 4) looks like this.There are 22 columns and 940 file names in COL A and COL J.below is just an example :) COL A COL B COL C COL D ...
0
votes
2answers
48 views

Coloring Bar Graph in Excel based on value

I have the following data Client Week Revenue Google 1 4000 Microsoft 1 5000 Intel 2 2000 ...
0
votes
0answers
19 views

Changing Pivot Page Field with Excel VBA 2010 “Invalid Procedure Call or Argument”

I have a very frustrating Excel 2010 VBA issue. I wrote code to change a pivot field based on a dropdown. The code worked like a charm until I first saved the file, to a .xlsm. Now the code only ...
0
votes
0answers
31 views

How can I change the grid sizing/positioning unit from Points to Pixels on VBA Forms?

I'm using Excel 2010, and I have a VBA form that I need to format. It seems that the Excel default is "Points". This is so frustrating because it can make sizing and positioning quite annoying. I ...
0
votes
0answers
24 views

Fast Get method in VBA then objHttp.Send “”

TI am creating a VBA script in excel 2010 that goes over vuln data looking for this regex patter MS[0-9][0-9]-[0-9][0-9][0-9], then does the following: objHttp.Open "GET", ...
1
vote
1answer
36 views

“catch” error due to missing privileges?

I have the following code inside a VBA-Script (inside an Excel[openxml]-Sheet): For Each Co In ThisWorkbook.Worksheets("META").ChartObjects Co.Delete Next Co When I open the Excel ...
0
votes
0answers
29 views

Getting 1004 error when setting a cell formula

I have a macro that has to insert a new row each time a button is clicked. The thing is that some columns must have a formula in them, this one for example: rating = "=IF(OR(ISBLANK($K$" & ...
0
votes
2answers
45 views

Weird behaivour getting value from merged cell

I've come across this behaivour in Excel. Given these cells: A B C D |---------|---------|---------|---------| 1 | merged cell text | foo | bar | ...
0
votes
1answer
40 views

Excel 2010 VBA: Auto width of DropDown combo

In Excel 2010, I have a worksheet with a dropdown combo. The combo is not an Active X, it as an form control. The combo takes its values from a table, and the table is re-filled by a vba macro, so the ...
1
vote
3answers
110 views

Data is graphing in Excel 2010, but not in Excel 2013

I'm using VBA to graph data in a program I created in Excel 2010. I sent it to another computer, which has Excel 2013 instead, and I found that everything worked perfectly except for this graphing ...
0
votes
1answer
52 views

VBA PivotTable Do not show subtotals

I am working on some macros to convert a table into Pivot and then to a CSV file. But I am stuck in remove the subtotals of the pivot table. So far: this is my progress. MACRO CreatePivot: Sub ...
0
votes
1answer
54 views

Excel VBA - Ignore continuous blank lines while save as a file

I am having some content in Sheet1 and I am doing some manipulations and writing them in Sheet2. The objective is to write the Sheet2 into a .txt file. The range is always going to be A1:A2320 from ...
0
votes
0answers
15 views

Pasting between worksheets issue

I am copy and pasting to a worksheet that I want to call in another instance of excel. (visible = false) That sheet will then take that same line that I copied and copy it to another sheet that is ...

1 2 3 4 5 … 14