The results are ruining my table/set of data/borders

[djb14128]

Hi VBA/Excel/IPhreeqcExperts,

I'm struggling to make this VBA script to work:

Please Login or Register  to view this content.

I'm sorry I can't upload the Excel file as it is way too large for it to be posted on here. I really want to get it fixed, but I don't know how to. The results/data keeps overlapping the next set of data/results below, ruining the table/set of data/borders. Many thanks.

[AliGW]

Please make a copy of the workbook and strip out as much as you can, leaving one small enough to post that illustrates the problem.

You also need to explain CLEARLY what you think is wrong and how you want it to look - the images are not clear enough. We are going to need a sample workbook.

[djb14128]

Here is as far as I can go with it. I was able to run Iphreeqc, I think the VBA code might be wrong. I'm not entirely sure because I've checked plenty of times already. Please ask me more questions, I'll answer them as much as I can. Many thanks.

[djb14128]

I think there is a problem with the For i = n To n+20 part of the VBA code. When I try to use For i = n To n it works perfectly fine. Only when I add the +20 does it fail. But I need to add that to make sure that I carry out the calculation again for the next set of data below.

[djb14128]

Bump............

[djb14128]

Can anyone help me? Many thanks.

[AliGW]

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - you have now bumped it twice in the space of half a day. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[Daishiknyte]

1) You do not have a Next for the "n" value for loop.

2) Every time "i" increments, you are moving down 1 row. The first loop copies rows 63-69 down to 83-89. The second loop through "i" copies 64-70 down to 84-90...and so on. The format for Cells is (Row, Column). From the pictures, it looks like you want to increment the column, not the row.