dowhile

This is my homework : find sum of 31st - 50th even numbers between 1-100 by using either do-while or do-until loop. Pls help me

Hi Guys, I have the below code, which looks through a folder for files and copies the data into my open workbook. I need the code to look for filenames only containing a string of ABC, and if the filename contains anything else, then X (The sheet to copy) would be 1 to 2 (Instead of 3 to 3)...

I am passing dates into variables labeled "Bx" using an increasing counter. There will be 45 of these variables so it will go Bx1 , Bx2, Bx3....Bx45. Code for this part: do while k<>46 Dim Bx(0 to 45) blah blah blah Bx(k) = blah blah blah k = k + 1 loop This works when defining variables but...

Hi, This is my first post, I hope someone can help. I have three columns of data and need to concat column 2 and 3 into column 4. Data Example: _ A B C D E F G 1 a a a 2 a a a 3 a a a 4 a a 5 a a 6 a a 7 a 8 a Where B and C are both present, I need them both to appear in D. Where B is...

Hello, I am trying to update files of one of specific folder. I am using Do While loop to update these files. But I want to add condition. If in these excel files there is particular sheet with previous month name then loop should skip that file & move to next. I am not even amateur in VBA...

I am working on writing a VBScript to run an excel macro only if a particular file exists in a specified directory. If the file does not exist, I would like the script to wait 10 minutes and check for the file again. Ideally, this script would continue running until a file is dropped into the...