looping through rows

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...

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...

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_...

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...

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>...

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...

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...

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%)