looping through rows

  1. ChloeLM

    Efficient formatting of specific cells by looping through...

    Hello everyone I'm a VBA novice who has muddled through a piece of code and got it working. However it's very long (and slow!) and i'm looking for some advice on how to make it more elegant (and efficient!) in order to speed up my procedure. Am i using an efficient way to loop through the...
  2. A

    Auto Create Charts from Different Rows in Excel

    Hello! I'm very new to VBA and have managed to create most of what I need; but am stuck on the hardest part IMO - Looping through the rows to create each chart. What I'm looking to achieve: Creating a chart for each row of data in my excel sheet. Each row of data has three years of monthly...
  3. Z

    Looping and sorting through blocks of rows

    Hello I am looking for a VBA solution I have a sheet with several thousand rows.The rows are split up into blocks of rows and seperated by an empty row.Each block of rows will vary with entries so these are random The sheet has 7 fields author,book_...
  4. DetroitDavid

    What's wrong with this code?

    Nubie here, trying to do something and it's not working, help is appreciated! On my sheet, E1 is a header. E2 to Ex (end of data) will have a single digit number 1-12 which I need to convert to a corresponding letter of the alphabet, A-L (1=A, 2=B, 3=C and so on). So if a 6 (currently...
  5. A

    VBA macro to extract data from one row to two rows

    Hi, I am trying to extract certain columns from a calculated row on a worksheet and generate two new rows derived from the original calculated row. Calculated data looks like this. <colgroup><col><col><col span="2"><col><col><col><col span="2"><col><col span="2"><col><col></colgroup><tbody>...
  6. A

    Macro needed to extract two rows from one row

    Hi, I have generated a row of calculated data and from that I want to split the data out into two other rows. Calculated data is displayed: aaa bbb cccc date figure 1 figure 2 xxxx yyyy I want to split it out like this aaa cccc date figure 1 xxxx bbb cccc date figure 2 yyyy This will...
  7. A

    Looping through rows and columns

    Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I’m sorry my question is a little difficult for me to describe, but here goes…<o:p></o:p> <o:p></o:p> <o:p></o:p> I need to loop through the rows in my sheet looking at the value in Column...
  8. R

    Looping through rows

    I have an Excel file with 2k+ rows. I need to create a macro that will loop through the worksheet keeping one record and delete 9. (Keep a sampling of 10%)

Watch MrExcel Video

This Week's Hot Topics

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
Top