looping through range

  1. R

    Looping through a data set and retrieving values

    <tbody> 1 Find Found 2 2 Red Clare Walker 3 3 Black Paul Binns 4 5 Purple Sharon Codd Result 1 <tbody> Blue </tbody> <tbody> John </tbody> <tbody> Smith </tbody> 2 Red Clare Walker 3 Black Paul Binns 4 Pink David James 5 Purple Sharon Codd...
  2. P

    Help With Looping through range and Locking all rows with Values

    Hi I have some code that is working as I intended with one minor exception. Upon clicking the userform button the code runs and adds a validation list to a specific column on the worksheets. It also locks all rows on beginning at a specified row down to the last row with data. It locks the...
  3. B

    Looping through cells within a range

    Hello Pros. I have an ongoing project I am working on but am stuck on this step. I have a range of data from "F22 (top left) to dynamic (bottom right)". It finds the range just fine. I need to check each cell in the range to meet a certain criteria. If it meets that criteria I will need to find...

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