automating a macro to increment row

**Plusone** · 04-16-2007, 07:32 AM

Hello!

I have built a calculator in excel in order to work out insurance premiums as a testing device for our software (to ensure the rate engine is working).

I have built a macro that copies information from a dataset and pastes it into the calculator in order to get a premium. This is fine, but i want it to do it over and over working from a different line of data each time.

Hopefully this is making sense.. so on the code below where it is looking at Row 3 of 'DATA' sheet, i want to increment by one every time it runs until it gets to row 1000.

Does anyone know how i can do this? I will keep checking the forum so if you have any questions please ask and i can give more detail. Many thanks.

Darren

---->code>

Please Login or Register  to view this content.

**mudraker** · 04-16-2007, 07:50 AM

Q1. Is it to process all the rows in 1 continous loop?
If yes where does the data go on the input sheet as your current macro uses 2 different rows in column B

If No Q2. Does it need to keep track of the row number only as long as the workbook is currently open - Starts from row 3 everytime the workbook is opened or does it need to always keep track of the next row number?

**sweep** · 04-16-2007, 07:52 AM

Please Login or Register  to view this content.

Should do it - use the & symbol to concatenate variable with column reference, and a simple for next loop.

HTH

Dave

**Plusone** · 04-16-2007, 08:05 AM

Sweep - that does the trick, great . The only problem is that its continually copying the first line only. So this will need to change:

Range("B3:T3").Select

Now, being a copmlete amature, is it as simple as inserting the ("B" & loopy:"T" & loopy) ??

I have tried this but get a syntax error at the moment, guess my syntax is rubbish....