for/next

  1. Z

    For/Next Loop Iteration Based on Specific Columns

    All, Below is the code I am working with Sub ExtractBST() Dim wsCopy As Worksheet Dim wsDest As Worksheet Dim lCopyLastRow As Long Dim lDestLastRow As Long Dim Current As Worksheet Dim I As Long Application.ScreenUpdating = False 'set variables for copy and destination worksheets Set wsCopy...
  2. V

    Do/Loop, If/Then or For/Next - Not sure which to use for this reiteration

    Hello Task: Calculate a value, only if the background of the cell is a certain color, then go to next row. I have been reading up on the Do/Loop, If/Then and For/Next statements, but having difficulty making any of them work. Here is the code: Cells.Find(What:=Util1, after:=ActiveCell...
    • Vanish29
    • Thread
    • do/loop for/next if/then searchdirection=xlnext work
    • Replies: 6
    • Forum: Excel Questions
  3. S

    For/Next instead of For Each with FileItem In SourceFolder.Files

    Hi all, I need to use a For/Next loop instead of "For Each FileItem In SourceFolder.Files" when looking at files in folder. Instead of: For Each FileItem In SourceFolder.Files next FileItem I need to use: tempFileIncrement = 1 iTotal = SourceFolder.Files.Count For q = tempFileIncrement To...

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