loop range

  1. K

    VBA - Texttocolumns- Loop through currentregion

    My requirement is that I have a range of cells which begins in B4 and ends in R507 (R507 is dynamic ; It could be s557 or af201 in another report). I want to do text to columns vba to each used columns Currently I'm writing code in this fashion which is pretty rudimentary and without loop...
  2. S

    Loop through multiple rows per iteration with Excel VBA

    How can I convert my Excel VBA code, which currently loops by each row, to loop through 10,000 sets, with each set containing 20 rows? I understand that the Step function might work, but I can't figure out how to amend my code to enable this. Basically, I would like to "paste" an array of 20...
  3. B

    Looping issue

    Good evening, I am trying to loop through highlighted cells, to use the script below to anchor multiple cells within formulae: Sub ANCHOR() Dim MyRange As Range Dim MyCell As Range Set MyRange = Selection For Each MyCell In MyRange ActiveCell.Formula =...

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