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 Now Value: Split Second

Please can someone assist. I've searched for this, but have not found anything suitable. I have a VBA macro which, when a character is entered in one cell, it places the current computer time in the cell adjacent. I've designed a timing sheet for rac...
more »

2017-10-03 13:10 (1) 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

Is there a way to find range of a pivot table

Excel 2013. I have pivot table, which grows and shrinks according to the data rows. For example, 1. For the Row label, I have list of all products 2. For the Column label, I have list of manufacturers 3. For the Values, I have a count of 1 for the ...
more »

2017-10-02 23:10 (1) 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

Run-time Error '1004' while pasting

I've been looking around to find out why this is giving me a Run-time error '1004' You can't paste this here because the Copy area and paste area aren't the same size. Select just one cell in the paste area or an area that's the same size, and try pa...
more »

2017-10-02 19:10 (1) Answers