Tagged Questions

0
votes
0answers
8 views

Copy, Name and Paste Table n Times

I have a single-column table, called Table1, beginning in A1 of Sheet1. I want to create n copies of Table1, name each successive copy as a defined name in Excel (Table2, Table3,... Tablen), and place ...
0
votes
2answers
10 views

Expected end of Statement Error on Simple Formula Insert

###.value = "=LOOKUP(LEFT(W2),{"C","A","B"},{"Pick Up","Collect","Prepaid"})" I want VBA to do this simple formula but getting "Expected: end of Statement" error. It seems that I need to define ...
0
votes
1answer
28 views

I need a VBA code to count the number rows, which varies from ss to ss, return that number and copy and paste that row and all other columns

I have vba question I have been trying to find the answer for for a long time. I have numerous spreadsheets from numerous clients that I run macro's on, I'm new to coding and have been able to mostly ...
0
votes
1answer
12 views

Excel 2010 VBA code to follow dynamic hyperlink

I have a worksheet with four columns A-D, column A has an ID number, B has description, C has location and D has a link to an image of the item. I have a short macro that ask the user for an ID# and ...
0
votes
3answers
19 views

Excel VBA - Cell(#,#) with variables

Im wondering if its possible to enter a variable that refers to a range into a Cell objects parameters. ie: Dim visibleRows As Range Dim visibleColumns As Range Set visibleColumns = (G:P) Set ...
-2
votes
0answers
23 views

Excel VBA Sort Populated ComboBox

What's the easiest way/code to alphabetically sort an already populated combobox in excel vba? I don't see a sort procedure as in regular Visual Basic.
0
votes
1answer
26 views

Making Few Row from a starting one

I give a simple example : i have a row that is made up of 2 columns , each cell of this row may contain more than 1 word. for each combination of words in each cell of the same row i have to obtain a ...
0
votes
3answers
23 views

VBA: Import Specific Variable Named Sheet in Workbook of Sheets to Access Table?

I'm looking for a way to import a specific tab into my Access table. Normally I do a TransferSpreadsheet type of code, so this is rather new to me. I need the user to be able to open the file from ...
0
votes
0answers
16 views

Paste bidimensional array of Double values with 3 decimal positions lose separator and turn into thousands

I'm trying to paste a two-dimensional array of Variant/String into a range. That's no problem. This Variant/String columns can contain strings or double values. All works fine except in those cells ...
0
votes
0answers
28 views

Excel VBA is screwing up my PivotTables

I have a bunch of PivotTables that can be filtered by Month and Year. I wrote a UserForm and macro to let a user change the filtered month and year with just a few clicks of a button. Unfortunately, ...
-1
votes
0answers
23 views

Print dates between range

I'm currently using Office 2003 to create a rolling forecast that can automatically update and populate. Because of my lack of vba knowledge I'm currently stuck on how to do a few things- I could use ...
0
votes
1answer
32 views

VBA Runtime error 91 Object variable not Set

I'm trying to select a range with todays date only, but receiving Runtime error 91 on the Cells.find(TodayLast).Activate line. I can't understand what seems to be the problem. Sub Escalation() Dim ...
0
votes
1answer
16 views

How to implement dynamic VLOOKUP in VBA?

I am trying to write a VBA function which will insert a dynamic vlookup command to the entire column (column "E"). My goal is to copy data from another sheet (called "WBTS"). Unfortunately, the syntax ...
4
votes
4answers
42 views

Open csv file delimited by pipe character “|” or not common delimiter

I'm trying to set up an excel vba code that opens up some csv files and split into columns the information contained and delimited by the character "|". I manage to open the file but the code I use ...
0
votes
0answers
22 views

VBA. Picture, decoded from Base64 string, needs to be inserted into Excel sheet

I need to store encoded PNG image in a vbs script, then launch Excel, decode stored in VBS base64 image, and insert this image into Excel. In this article I found decoding solution. Finally, I got ...
0
votes
2answers
28 views

Why is my project calling another projects code?

Currently I have two versions of an excel addin - The released version, and the current WIP version. When I load both into Excel and try to run the released code, it calls my WIP code instead, which ...
-5
votes
0answers
37 views

Book for VBA (TheGood Parts) (and maybe Excel) [on hold]

I am trying to get competent at VBA and the Excel object model. I am coming to Windows programming after a long time in Unix-like systems and a couple of embedded applications. I have done lots of ...
1
vote
1answer
35 views

autofill down according to adjacent column

I'm looking for VBA code that will autofill data down according to the length of an adjacent column. I know there are a few ways to go about this, but which is best?: If LastRow > Selection.Row ...
1
vote
1answer
32 views

Folder Selection Dialog Box (VBA, Excel 2010) causing files to be unreadable

This may be quite a lengthy description, so please bear with me. The problems I am experiencing with Excel are related to custom macros, VBA, and file access. Background: I am trying to write a macro ...
0
votes
3answers
37 views

Copying Row Info from one sheet to another based on match

I have an excel book that has two sheets: 1) Import 2) Pricing Rules. Pricing Rules Sheet The A column is what I need to match on. Example values include STA_PNP4, STA_PST.. and others. There are ...
0
votes
1answer
36 views

Rolling Date Macro

I'm currently using Office 2003 to create a rolling forecast. I have a starting point and end point for a time interval (yr/month to yr/month) that I need to populate automatically at certain ...
2
votes
2answers
37 views

XmlHttp Post in Excel VBA not updaing website form

I routinely have to search the state of NV for unclaimed property and put the results in an excel spreadsheet. In trying to automate the process but I'm limited to using Excel 2010 and VBA. Below is ...
2
votes
2answers
71 views

Select Case Loop

I modeled a Select Case loop based on another question I found on here(Link: Excel VBA Select Case Loop Sub). The changes I had to do to make it applicable were pretty minimal, and I don't see where ...
-1
votes
3answers
41 views

Delete entire row if value is greater than or less than? [on hold]

I am new to VBA for excel and I am stuck with a little problem. I have to delete an entire row if the value in column C is greater than 40000 or less than -40000 (these are data outliers). The list of ...
1
vote
4answers
48 views

Display 3 values in a message box with spaces between the values

I am trying to display 3 values in a MsgBox. My logic statements are working, and it is picking the correct values I want - however I am unable to make my message box display 3 separate values with ...
-2
votes
1answer
35 views

How to locate a specific Tag whose position is not same in each excel files and read the measured value column for that specific tag

I have 1000 Excel files which I have narrowed down to 100, but in those 100 files my search has to look for a particular id tag. Let me explain, each Excel file has different id tags, these tags ...
1
vote
1answer
27 views

Getting ActiveCell value in excel FROM word macro

I am trying to manipulate an excel workbook from word. Everything was working quite well until all of a sudden I couldn't get a response from ActiveCell.Value The problem is happening all the way at ...
0
votes
0answers
31 views

Reference a cell based on embeded button location

The user can enter certain parameters and it will pull up an array of cells fitting those parameters in 3 separate columns. I need to reference those cells based on the row my form control button is ...
2
votes
1answer
25 views

FormatConditions border on a single edge

I am trying to add a border between rows when the data in column 1 changes. This code breaks at .LineStyle = xlContinuous. The error I get is "Unable to set the LineStyle property of the Border ...
0
votes
3answers
43 views

object required error Sheet1

Sub combine() Dim inName, inNum, inCity As String Dim IncNum As Integer Dim temp As Range Dim lrow As Long Dim counter As Integer Dim cityCells, sNameCells, sNumCells As ...
0
votes
1answer
57 views

Faster way to add formatting

I have 234,000 rows of data and a macro that applies formatting to it. The macro takes about a minute to run. I'm trying to cut the time down if possible. Each time there is a change in column 1 a ...
0
votes
1answer
29 views

Method name of object _chart failed

I am getting a Run Time error 1004 :Method name of object _chart failed while I try to name my chart. Sometimes this runs, and sometimes it doesn't. Here is the part that causes the error, (the whole ...
0
votes
3answers
37 views

Setting a delimiter to generate an export

I found a VBA code that almost fits my requirements to export data to a CSV file. I am having problems with the delimiter function. I have the following function: Function DelimitRange(ByVal XLArray ...
-1
votes
3answers
72 views

Get and edit a file name

I'm looking to retreive a txt file and then edit the file name (adding "converted" to the file name) and extension (from .r01 to .txt). The purpose for this is so I can know if the txt file has been ...
0
votes
1answer
29 views

split orasql query into multiple workbooks in Excel using VBA

I am trying to split my ORASQL query into multiple workbooks with a specified number of entries for each book. I am using office 2010 if that matters. I think I should use what is below (from a ...
0
votes
1answer
41 views

Modifying and appending to SQL tables using Excel VBA

OK, so I have some VBA I am wanting to use to update and add data to a table on an SQL server. I have been muddling through with limited knowledge of this functionality within VBA all day, searching ...
-4
votes
0answers
58 views

Chiinv function in VB [on hold]

I'm having problems writing the formula for the CHIINV function I had on excel. I'd like to find out the equivalent of the excel function CHIINV which is useable in Visual Basics. I attempted the ...
2
votes
7answers
90 views

How to delete entire row in Excel if a cell contains a specific value

I have the following dataset: A B C 1 dog232 cat3e12 mouse23 2 cat4234 cat21 mouse12 3 mouse312 mouse13 dog32313 I want to write a VBA subroutine ...
0
votes
1answer
49 views

VBA Project Password-Protect with SendKeys not Working Correctly

I've spent the last two days working on this problem. Most of the content I've found on this topic doesn't address the issue I'm having, so I'm hopeful that someone here can help me. I've been ...
0
votes
1answer
45 views

Automatically Copy Sheet 1 A1:A2 to Sheet 2 A1:A2 When Sheet1 A1:A2 Changes

Objective: If any values in A1:A2 on sheet 1 change, then the values in A1:A2 on sheet 2 should automatically update with these values. The following sheet 1 event handler fails to work: Private Sub ...
-1
votes
3answers
68 views

VBA Macro Speed Up

I would appreciate some help on the following VBA Macro problem, screenshot here: I have to compare the data in 2 columns - Index & Sec_Index. In case of a match it should check which Values is ...
0
votes
2answers
36 views

How to build non-consecutive ranges of rows based on cell contents?

I'm just getting started with VBA for Excel. I used VB and Java in college nearly ten years ago and was competent with it then, but am essentially starting over. (Um, not like riding a bike.) I am ...
0
votes
1answer
39 views

Excel vba script for special arrange in one column data

the script needed is to re arrange cell, before Human:Annie [Fruit]=Banana [Fruit]=Mango [Fruit]=Apple Human:Jack [Fruit]=Apple Human:John [Fruit]=Mango [Fruit]=Papay after Human:Annie ...
0
votes
2answers
33 views

How can I reduce the size of my statement for Excel to txt file and skip empty cells with no data

How can I reduce the size of my statement for Excel to txt file and skip empty cells with no data. Below is a small portion of my code but is at least 204 lines long and very redundant. Private Sub ...
1
vote
1answer
49 views

Excel VBA macro for a complicated Copy Function

I am new to VBA though I have done some coding in other languages so I understand some general concepts. I need to write a macro for excel that copies some data from a workbook in a single column that ...
0
votes
0answers
13 views

Edit control text in custom toolbar is blank in Excel 2013

I've got Excel addin with a vba edit control on a toolbar. This has worked for a long time under Excel 2003-2010. But under Excel 2013, the text property is always empty regardless of what gets typed ...
0
votes
1answer
54 views

Find last row containing data

I import RAW data into Excel. I want to create a macro to filter the data and to remove data that has been filtered out. The length of the RAW data report varies so the number of rows containing data ...
0
votes
1answer
29 views

VLOOKUP With Another Worksheet

I get a "Subscript Out of Range" error. I have two Workbooks. I am trying to VLOOKUP values into each sheet of Workbook A from its corresponding sheet in the Workbook B. The sheet names are the same ...
0
votes
1answer
21 views

Making independant groups of option buttons

I am looking to make sort of a little form with groups of checkboxes and option buttons which will later feed a vba code. I need to make group bokes with 3 option boxes in them but independant. As it ...
0
votes
2answers
38 views

Excel VBA: Can't get a match, error “Unable to get the Match property of the WorksheetFunction class”

For the love of all that is good, I cannot seem to get this to work. I keep getting the error mentioned above. I have this table, and I'm trying to find out whether the code matches it's own ...

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