if then end if

  1. A

    Coloring Cells depending on Hourly Schedule Table

    Hi All, I am new to making macros with color conditions and I have been having trouble figuring out the logic to my code. I have a table with various rows of jobs with their start and end time on a given day and each of these jobs can pass through multiple machines which are also included in...
    • aroig07
    • Thread
    • cellsk conditional cell colour end gantt chart if then end if
    • Replies: 0
    • Forum: Excel Questions
  2. V

    Replacing < and > with numbers using If Then loop

    I want to scan a column of numbers that occasionally contain some values that have either "< 0.000" or a "> 10" listed. When I find them, I need to write a slightly different string set to an adjacent column. I also need to write an integer to a third column as a FLAG. So when I find the "<...
  3. O

    IF a value in one column is => 10,000, Yes in next column or no in next column if false

    Thanks in advance, and I will let you know what final result works. Objective: Within the same sheet if column J entry >= 10,000, Then Column K = "Yes", Else Column K = "No". The number of rows in the worksheet will vary when I use this sheet so I want to make it find the last row. Sub Value()...
  4. B

    Categorizing Column Values Using Multiple Criteria

    Hello all, I am working with an aging report where data is formatted in column. In the last column I would like to assign a value based on criteria from the adjacent columns (ex: If balance > $10,000 then value = "Hold"). My idea was that I would asign variable to the column, start a for next...
  5. Y

    Loop a Macro-Insert New Data Below Previously Entered Data

    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...
    • Yao567
    • Thread
    • do until loop if then end if loop a macro vba & excel 2010 vbyesno
    • Replies: 1
    • Forum: Excel Questions
  6. J

    Macro not working

    I have the following macro to print reports. But only the 1st report printed even when the cells C6 to C8 all contains "x"? Did I miss out some steps? Thanks so much! My Excel is Excel 2010 version. Regards Joseph MACROS Sub PrintReport() If Range("C6").Text = x Then...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top