Access VBA reserved word "name"

I am using Access VBA to access movie information using the API. It is working fine but I have a problem with attributes that have as name the word "name" which is a reserved word. Let's say I want to access the production companies. I am using this...
more »

2017-10-04 17:10 (2) Answers

Copy value to next empty cell

I want to find empty cells and copy there values: Values: "10/11/2017" and "Yes" should be copied to row 7 (colB & colC). What I have: Sub add_value() Dim wbA As Workbook Dim wsA As Worksheet Set wbA = ActiveWorkbook Set wsA = wbA.Workshee...
more »

2017-10-04 11:10 (2) Answers

Error re-running code

firstly, I'm having error running the code from Excel workbook directly. It leads to the error message mentioned below We looked at all the data next to your selection and didn't see a pattern for filling in values for you. To use Flash Fill, ent...
more »

2017-10-04 11:10 (1) Answers

VBA SaveAs crashes

I have an xlsm file named Summary.xlsm. The Summary file gathers data from xlsx files in the same folder it's in. The folder the Summary file is in should only contain other Excel files named IEM_######.xlsx (IEM_ plus any six digit number), but some...
more »

2017-10-03 20:10 (1) Answers

VBA - finding value based on two criteria

I'm looking for a solution to create a search function based on two dynamic values/criteria. I have a userform, with a combobox and a textbox. Criteria 1 is coming from a combobox and should be found in (Column Building Material). Criteria 2 is a l...
more »

2017-10-03 19:10 (0) Answers

VBA hide column if

I hope you can help me with this challenge that I have in Excel VBA. I'm not sure how to explain this, but I'll do my best. I want to "hide" two columns if, the two columns contains the same text in both cell "D4" and cell "E4". The text in the col...
more »

2017-10-03 18:10 (2) Answers

VBA, Optimize VLookup/Formulas

I have a code, largely done from the macro recorder. Runs very slow. I think this is due to the vlookups or formula, can anyone help make this code faster? I also have filtering and copy and pasting, doubt these are slowing this down. Perhaps it is ...
more »

2017-10-03 17:10 (4) Answers

excel vba Delete rows until criteria

I am new to Excel VBA and could really use some help. I tried searching for a solution throughout the web but was unable to find a similar problem. I am trying to create a macro that will help to delete Rows based on certain criteria and continue de...
more »

2017-10-03 17:10 (1) Answers

How to select cells NOT containing a certain word

I have an Excel table, in which some of the cells of the C column contain the word "Rinse" (the other cells have various other contents). Using VBA code, here's how I would select all rows containing the word "Rinse" in the C column - this code work...
more »

2017-10-03 14:10 (6) Answers

Setting the Row Height dynamically in VBA

I have a requirement, where I have to set the Row Height dynamically. For Example, the Input looks like - And I want my output to look like - The String in that line will keep changing. So, now based on what characters, I should set the row heigh...
more »

2017-10-03 13:10 (2) Answers

Excel VBA Nearest Value in Array

I have the following data in a array Dim numbers () numbers = Array(1, 2083, 3050, 4030, 6000) I want to get the closest value from my array when i put a number in Range("A1") ...
more »

2017-10-03 10:10 (2) Answers

Excel - Looping issue

I have a sheet that looks like this: -------------------------------------------------- | cat | cat | cat | dog | bird | dog | dog | dog | -------------------------------------------------- | | | | | | | | | ---...
more »

2017-10-03 06:10 (2) Answers

Excel Date/Time Lookup Error

I have two columns of 15 minute date/time interval data. One is formatted in 24-hour time and the other 12-hour. These come from two different sources, and reformatting the source data is not an option. All of these intervals are showing as exact mat...
more »

2017-10-03 05:10 (2) Answers

vlookup to leave cells empty if value is 0

I have written this code so far but is says that there is an application or object error.. .Formula = "=IF(VLOOKUP(A2&""B2"",MARM!A:G,7,0),"""")=0,"""",VLOOKUP(A2&""B2"",MARM!A:G,7,0),""""))" I have used this code so far successfully but ...
more »

2017-10-02 21:10 (0) Answers