do until loop

Hi, I'm scratching my head around what I think "a very simple piece" of code...but I'm a VBA beginner I have to perform 2 tasks, and while I've completed the first one, the other is giving me a lot of troubles... 1st step: clear the content of a range of cells when I switch the xls validation...

Hi all i have a spreadsheet that has various column with dates in and other columns with names in. i would like a macro to look through each column one row at a time, check for dates less than today and present a message box to say "x persons name has a deadline due" and add that date that is...

Mr. Excel, I am attempting to find/write some VBA code for looking at a manufacturing Bill fo Material for a finished product, and deleting any Bill of Material Lines below purchased parts. Assuming the "Line#" heading below is in cell A1, can you help me with some VBA code for this? The...

Basically Once This code ends i make a msgbox asking if you want to run it again. If yes then it runs, but i want to do it infinitely till you tell it no. I think i could do it with do until so I pretty much got that. This issue is how do I tell it to put the new set of data under the...

Write a function that calculates f(x) = 1/(1+x) Create a table (see below) with an x-column and calculate the values for f(x) into the y column using your user defined function. Calculate and display f(x) up to 5 decimal places until the value for f(x) does not change any more after 5 decimal...

Hi, New to this forum, so I apologize in advance if this is being placed in the wrong section. I'm working on replicating a formula that I currently have created without VBA, but excel limits its functionality. The context of this formula is as follows For C1 if B1 = false then C1 = 0, else...

Hi Guys, Have a Macro that I want to stop the loop when the ANYWHERE on the sheet does not have the Cell.Value "Net Assets" This is what I have got but it is not feeding correctly. Could someone please tell me the adjustment I need? Thanks Do While ActiveSheet.Value <> "Net Assets" Is Nothing

Hi, I want to loop until the last cell in another workbook. Both workbooks are open. Here is some of my code. I can't get the loop until part to stop at the named range of Wk2. any help would be appreciated. Set Wk1 = ThisWorkbook Compare = InputBox("Favor selecionar a data para comparaçao...

Excel 2007, Windows XP Pro Dim strLoan As String Dim longCat As Long Dim rHere As Range Range("A1").Select Do ActiveCell.Offset(1, 0).Activate strLoan = ActiveCell.Value Set rHere = Selection If ActiveCell.Value = 0 Then Else On Error Resume Next Cells.Find(What:=strLoan, After:=ActiveCell...

Hi everyone, The below code is designed to pick up variable levar from a list of values in the Masterlist tab and colour each row from the JDE Cardex tab in which levar appears. While it does this, the code would not stop searching for levar once the Do Until condition is fulfilled and thus...

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 =...

background: I have files that have file names 06-01-11, 06-02-11....ie dates. I am trying to return file names going in date order (part of a larger thing but this is the piece I have having issues with). for now, I am just trying to get a message box to show me the proper file name (one...

Hi everyone. I could really use some help getting the following code to work. In my spreadsheet budget data is displayed horizontally by month. Oct-10 Nov-10 2000 500 2345 1111 1233 I need it to be displayed vertically with the month next to each expense. Oct-10 2000 Oct-10 2345...