current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0

Tagged Questions

0
votes
1answer
14 views

Excel VBA using Find to update data in different worksheets

I'm trying to create a Macro that will allow me to compare data in two worksheets and update based on any differences (updates, insertions, deletions, etc.). This what I have so far - but it keeps ...
0
votes
0answers
11 views

Excel.exe*32 not closing in task manager. Runing VBA from Access. Runing Office 2013

The excel.exe*32 process remains open in the Windows Task Manager even though I am closing it in VBA. I am running the following VBA code from Access. I have looked and tried various solutions to no ...
-2
votes
1answer
28 views

VBA excel passing an array to sub fired by button

As in title I would like to pass an array to the sub which is executed by a button (That's why I don't know ho to pass it to the sub). Array is calculated in the Sheet before you can exectue sub with ...
0
votes
2answers
44 views

Excel VBA Application-defined or object defined error

I'm struggling with this bit of VBA code. For some reason I keep getting: "Run-time error '1004': Application-defined or object defined error" message. My only thought on why this may be is that I ...
0
votes
2answers
15 views

Comparing two Cells in two different Worksheets

I keep getting the following error message when comparing two cells in two different worksheets: Run-Time Error '1004' Application-defined or Object-defined Error For j = 2 To 10 For k = ...
0
votes
2answers
16 views

Type Mismatch Run Time error 13 for excel VBA

I have requirement to write some function which will accept Range as input and I need to return value of first non empty cell. I have tried in one excel sheet and finding non empty cell was working ...
-7
votes
0answers
23 views

Have some quick queries on macro can you please help me? [on hold]

Please Help!!!!!!!!!! I need to copy paste file from one folder to another and then rename the files to present month and clear content in all the excel file and all the worksheets within it. Nextly ...
0
votes
0answers
19 views

store intersection column into array failed

I wanted to store some columns into array, so I use Union. Set ws = Application.Worksheets("data") k = ws.Range("a65536").End(xlUp).Row arr = Union(ws.Range("A2 :C" & k), ws.Range("M2 :N" & ...
-3
votes
0answers
27 views

Excel macro to generate sql create table [on hold]

Hi I need a help on the below scenario. I have a below excel sheet STUDENT S_NAME CHAR 10 1 STUDENT S_LAST CHAR 10 2 STUDENT S_GRADE CHAR 1 3 STUDENT S_MARK NUM 0 4 TEACHER T_NAME ...
0
votes
0answers
10 views

ActiveX component can't create object. Hasp in Excel VBA

I wanted to create object of HASP app in VBA in Excel, but I have such error: Run-time error '429': ActiveX component can't create object. I installed hasp_com_windows.dll in SYSWOW64 folder and ...
1
vote
1answer
19 views

Excel VBA OnTime for less than 1 second without becoming Unresponsive

I have a userform which runs a script every 100ms. The script handles images on the userform and is used to animate them, while the form continues to receive user input (mouse clicks and key presses). ...
0
votes
3answers
24 views

Debugging VBA code - appending values to array

I am trying to use code of the following form to populate an array of x rows: Dim myarray() As Variant Dim string1 As String Dim myarray_ubound As Integer myarray_ubound = 0 For i = 1 to x ...
0
votes
0answers
12 views

Add-ins not loading when opening excel file programmatically

I've seen some similar problems described by others before but no real solution. And I'm sure there is one. I have a .XLA-add in configured to be loaded when I open up Excel. It works fine when I ...
0
votes
0answers
12 views

VBA QueryTables.Add fail to import text data in newly created sheet

Private Sub CommandButton2_Click() Dim MyFile As String Dim s As String Dim sheetname As String Dim curFile As String Dim dirpath As String Dim dirpathwild As String Dim ...
-1
votes
1answer
24 views

Excel.Application.Cells.SpecialCells(xlCellTypeLastCell) returning bottom of worksheet, not last data cell

I'm writing a method in VBA in Excel 2013 to loop through the rows in two worksheets and compare the text in a column from each. However, when I loop through, I'm finding that the code is looping ...
0
votes
1answer
44 views

Extremely slow VBA code when formatting cells

When attempting to format 2 columns in a workbook, the execution of the macro is extremely slow. To format approximately 4000 rows, it takes over 10 minutes. The dates are populated from an external ...
0
votes
2answers
24 views

VBA to paste only values instead of paste every thing

I am working on a small project which requires me to search for a word through one column then copy the entire row that contains my word into another sheet. This is my code and what I have so far: ...
0
votes
1answer
48 views

Can someone help me optimize the VBA loop in excel

My worksheet have 6000 rows. This loop takes me more than 20minutes to finish. It is too long for me because I have many columns to run this loop. Can someone help me? Dim i As Integer For i = ...
0
votes
1answer
28 views

excel VBA : how to skip blank cells between 2 cells that contain values?

I am working out a button that can auto sum value at column C that column A = column B like the picture : PIC: I can only copy the value in column C (that the word in column A = column B) to column E ...
0
votes
0answers
30 views

Excel VBA - Split multiple sheets to multiple files with pre-defined format

I have a master file with 3 sheets as below: Sheet 1: (has 8 columns, I just use 2 columns as example) NAME VALUE1 A1 1 A1 2 A2 2 A2 3 Sheet 2: (has 9 cols) NAME VALUE2 ...
0
votes
0answers
16 views

Excel custom function, time execution (runtime) issue in a conditional sum

APPROACH: I have the following Excel sheet called “Daily Planning” for daily planning of tasks for some projects: http://es.tinypic.com/view.php?pic=i4pp4w&s=8#.U945LWMs8tE (I can not upload ...
2
votes
0answers
40 views

Excel VBA repeated change of a control cell hogs memory

I have searched on the web quite extensively, but have not managed to find any similar experiences. Any ideas? I have a simple subroutine in VBA that changes a control cell. This control cell is used ...
-3
votes
2answers
37 views

Using Excel VBA to Find, Convert and Replace Currency in a String

I have a Cell with a String like this (H/Y): As per un-audited half yearly accounts as on 30.06.2014 (Jan'14 to June'14), the Company has reported consolidated net profit after tax (excluding ...
0
votes
1answer
21 views

Sum function referenced to column number VBA

I need to reference columns by number in Sum function (i.e. Column B =2, C=3, E=5, etc) i tried this code but it didn't work (ColN is the column number read from a listbox index) Range("M5") = ...
1
vote
1answer
27 views

Why is my subscript out of range in vba?

I wanted excel to go through every single cell of a column, perform an operation on it and then copy the results on another column. This was my initial code: For i = 2 To dataRows ' Cells(i, ...
0
votes
1answer
49 views

Macro from Word does not work in Excel can it be modified for excel?

I realize that it is probably not supposed to work, but I have this visual basic code from a Word Macro that opens a piece of software linked to a piece of fluke equipment connectded to the computer ...
1
vote
2answers
34 views

VBA - Set Range for function Based on Header Value

Im fairly new to VBA so I need some help with this project I'm working on. I am trying to write a script that is easily scaled and extended so I am avoiding hard code values as much as possible. I ...
0
votes
0answers
37 views

Match Columns heading and Copy data across 3 worksheets

I have been trying to solve this issue for several days now with my limited VBA knowledge. I have also searched several forums and google in order to the desired solution but to no avail. While ...
-1
votes
0answers
21 views

VBA Code doesn't work on MAC

In follwing code I am pasting a Chart Object first and then trying to change alternative text property of pasted Chart (as a picutre). .ChartObjects("I_Chart").Copy ...
0
votes
0answers
31 views

Get Vertical String From Another Program And Paste Horizontally In Excel

Generally I link our accounting software to Excel using VBA macros. For the last few days, I have been trying to write some code but I am failing to get the desired output. The problem is explained ...
0
votes
0answers
23 views

Excel VBA: Populate combobox with column A if B = xxx

I'm relatively new to VBA and I'm stuck here. I have to populate a lot of dropdown menus (combo boxes, most of them in userforms) based on one database. The dropdown menus are in the sheet "TeamChart" ...
0
votes
0answers
39 views

Excel Macros: create dynamic sql by reading values from a column in the worksheet

I am creating a macro sheet wherein we'll be firing queries based on the query id selected at runtime. Eg: When a user runs the macro, he will be prompted for entering the query id. {completed} ...
0
votes
2answers
27 views

Subscript Out of Range Error in Code

I have a macro that moves data from a master sheet to their respective sheets in a workbook by group and then creates a separate workbook of each of those sheets... But I have been getting an error ...
0
votes
1answer
33 views

How to obtain the data from cell from 500 .xls Excel files?

I'd like to ask you how can I get the data from few determined (and always same) cells from many Excel .xls files, I.e. I have a list of .xls files in one folder, and each file has the same table ...
1
vote
1answer
27 views

Strange behavior from VBA DataObject. GetText returns what is currently on the clipboard

I posted a question earlier about an error raised by the MSForms DataObject as accessed from Microsoft Office Excel 2013 VBA. As I was writing that post, I discovered other odd behavior that is even ...
0
votes
1answer
19 views

VBA Excel Context Menu - Hide all buttons and add my buttons only

I am looking for a way to hide all the buttons from the Excel context menu and just leave my buttons I created. I haven't found about it on internet. How can I do that? Thanks!
0
votes
1answer
15 views

Copying information from a master sheet to it's feeder sheets.

I have a work book that I am using to track volunteer hours. I often get new volunteers. Is there a code I can use to add a line item in each month from when I add a name to the master. EX> of ...
1
vote
1answer
21 views

Copying cells from one workbook to another works on step through but not when run

I'm writing up a sub which grabs specific cells from the active workbook (order form), opens a specified workbook (report) and drops in the values in a particular order. Oddly, this works just fine ...
0
votes
0answers
32 views

DataObject.PutInClipboard raises error “Not Implemented”

I'm attempting to use the MsForms DataObject to preserve the contents of the windows Clipboard during VBA code operations which use Copy/Paste methods of the Range object. Unfortunately an error is ...
1
vote
2answers
48 views

Excel VBA: Looking for Advice Avoiding an Infinite Loop

Imgur Album with screens of worksheets: http://imgur.com/a/6rFWF Long story short, I am writing an Excel VBA utility that will assign two types of security shifts (called coverages and weekend ...
0
votes
2answers
32 views

“Out of Range” error using record function to sort on Excel

I have a bit of experience programming but I have absolutely none with VBA. I have been using the record macro function in Excel with success, but I run into problems when I try to do a sort. All I do ...
2
votes
1answer
48 views

Disable all dialog boxes in Excel while running VB script?

I have some code in VB that saves all XLSM files as XLSX. I already have the code that will do that for me, but dialog boxes show up for every action. This was fine for a few dozen files. However, I'm ...
0
votes
1answer
42 views

Using a tree data structure in VBA

I am getting more familiar with VBA and I am attempting to do a machine learning program for Tic Tac Toe. I don't want to just hard code the possibilities to win. The best I have come up with for a ...
0
votes
1answer
30 views

Calling an existing worksheet with vba by using its code name in excel

I am trying to set the formula of a cell to an if formula that uses data from an already existing sheet within the workbook. However whenever trying to reference the sheet i get a file dialog box ...
0
votes
3answers
28 views

How would I put VBA process into a loop?

Edit: I figured it out, thanks to a helpful post. My final code is below. I am using Excel, and I've got this VBA script that looks for a string, copies it, then pastes it two cells down. What I'd ...
0
votes
1answer
22 views

Monthview Bolding Every Value

I created a Monthview and TimePicker in a form. I want the user to pick the time, and select a month which will bold the value selected each time, then select OK which will insert the value. I have ...
0
votes
4answers
38 views

Looping through cells, building a range in VBA

I am looking to loop through cells and build a range for a graph. My main issue is that I cannot figure out how to incorporate the 'i' into the range. Example: Dim name As String Dim newChart as ...
0
votes
2answers
30 views

VBA Excel: Function to output next quarter from input date

I'm working in vba for excel and need the use of a function that I can input a date that is in the format of the excel converted date (such as 40736). And output the date of the quarter immediately ...
0
votes
4answers
37 views

VBA Summing a Column of Variable Length

Another VBA question (I'm on fire lately) As the title says, I am trying to sum a column that can can be of a variable length and then stick that sum in cell F3, but I am running into a an ...
0
votes
1answer
32 views

Trying to make a code with VBA for excel

Trying to make a code for a spreadsheet I'm working on, I do not have prior experience and found an example online. The first part of the code works fine, but when I try to bring in the second "if ...

1 2 3 4 5 … 212