loop ranges if vba

  1. ClwnMan76

    Calendar Coding Using Conditional Formula With A Color Code Of Users Choosing

    I'm having trouble learning this "loop" feature in vba, or even if it's the correct way to do what I'm wanting. I'm looking at changing the day's background fill, or the "interior". I figured out how to do it one box at time, but it seems as though that probably isn't the BEST way to do it and...
  2. O

    vba loop script

    Hi All, I'm trying to write a vba loop script for a list of numbers. The scrip should do: 1. Check if the numbers identical. 2. If the numbers identical give a serial number that will count the identical numbers. 3. if The numbers do not match, then start a new series of serial numbers...
  3. N

    Create/Save New File per change in column

    Hi Guys, I have a macro that allows me to create a file where there is a change in the name of the column and save it with that new name: Sub FindNextCustomer() Workbooks("Book1.xlsm").Activate Sheets("Customers").Activate Range("A2").Select b = Range("A2").Value Do While ActiveCell.Value =...

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