do while loop

Please help me understand where my syntax is wrong here! I'm a beginner in vba but am learning fast. I'll try to simplify the problem below. I have created an array called myArray(). It has 5 values, 1,2,3,4, and5. I've confirmed the array was created successfuly. I then have a loop where h is...

Hi, I need to do a couple of do whiles with an IF that validate if a cell it's equal to a number (locations codes) then delete the entire row, (I need them in 2 different macros) And the issue is that I have 90 locations codes (for now) So, how can I create this kind of "database" as simple...

Hi All, So I have been struggling very much with setting up a series of Loops and Do While functions in order to pull results from specific tabs, and from specific rows and columns on these tabs (based on known information). Simply: I have two columns to populate with data -CompanyA...

I want to look at a list of dated files and open them in order. below is my code. Dim loopcounter As Integer Dim rptdate As Date Dim datafilename As String Dim datafilelocation As String Dim fulldatafilename As String Dim fulldatafilelocation As String rptdate =...

I have multiple folders(level 1) with folders (level 2) in them. I want to delete the level 2 folders (but not all of them). so I want to go in to folder 1 and delete folders a-g (but not h-z), then move to folder 2 and repeat the same thing. I have the list of the folder1's in column a...

I am attempting to create a do while loop to loop through the following date ranges and several into the future. 06/23/2011 to 07/7/2011 07/7/2011 to 07/21/2011 07/21/2011 to 08/4/2011 08/4/2011 to 08/18/2011 The following code runs when a command button on a sheet is clicked. Private Sub...

Hi All, I have some code that checks a series of worksheets in a workbook for specific errors based on indicators in the field heading and then outputs dynamic hyperlinks to the cells with trapped errors in an error report. I'm having a problem with the Do While loop that I'm using to comb...