loop command

I am new to the VBA language and coding. I have a folder with 51 Excel files. In each file there are specific variables between cell J4 and cell R4, included, that I want to tranfer into an inclusive excel workbook. The code that I am using is the following: <code>Sub...

Hey everyone, I trying to figure out a formula for vba, where it checks to see if the the second row is blank. basically if row 2 is blank, do nothing else, carry out program. Writing a monthly report, so some months there's no data in the table, and just want to make sure it doesnt carry...

Hello, My Question is need to display a text value "Started" & "Completed" cell a1 has start date Cell B1 has End Date display c1 "Started" or "Completed" based on the a1 and b1 dates.. a1 = 10th may (10-05-17) b1= 20th may(20-05-17) I have one more cell also , total number of...

I want to refer to the last date of the data set and make the cell value move UP until cell value is equal to text or in this case "BRL" If it is text, I want excel to run the formula in BLUE, otherwise I want excel to move up the column until it finds a text. =IF(ISTEXT(A9)...

I am looking for code to check each worksheet in the active workbook for ending row number, if final row is x and last cell contains phone number continue, otherwise pause and allow worksheet correction. When corrected, continue through last worksheet. I have no idea where to even start on this...

Maybe someone can help me with this? I have a loop going through a column to see if anything is not zero. If there is an error in one of the cells I want is to go to the error handler and perform a set of statements. However, I'm getting issues with the loop not ending as the variable will not...

Hi all, I worked my way around this macro. What is does is that is will open an xlsx, copy all the data and drops it in a specific sheet inside the workbook. The path of the file to copy is in column H. The Sheet name of the to be pasted data is in column I. Now i am looking for a way to loop...

Hello, I have a problem in copy pasting records which match a user defined criteria. A user can define a criteria and hit 'run' button. Records which match criteria are copied from a different sheet (same workbook) and should be pasted into a table on the active sheet without spaces. There are...

Group, I have a very simple For/Next Loop that simply says: For rowNo = 2 To 2000 Go do some stuff Next rowNo However I need to insert a "Goto the next iteration of this loop" in a IF statement. However I'm struggling to find the correct syntax to make this happen. Can you help? I need...

Hi all I need your valuable expertise in modifying/tweaking the below code a little bit to make it work wonder. From below, myCell is a range of values containing the name of the files to be saved got produced out of this macro. Instead of providing the fixed path/folder to save produced...