Looping question

Note that loops aren't always the most efficient way of doing things. This loop works for rows 1 to 100. You could look into the Cells rather than Range notation as it is slightly more intuitive, at least for people like me who never stop having to think which is the row and which is the column.

Please Login or Register  to view this content.

EDIT: DonkeyOte is ahead of me and read my mind.

Thanks for both those guys, they look like what I need, but for some reason I am getting an "Overflow" error on both codes? When i debug it says it is this line that is causing the problem

Please Login or Register  to view this content.

shak

Perhaps a value in column I is zero or blank?

Yeah I just realized that, I have blank rows in between some of the data I want to calculate so it is trying to divide by 0 on these rows. Is there anything I can add to the code so that it skips rows that are blank?

Shak

You could extend your initial If statement. If possible, best to avoid blank rows in your data.

Please Login or Register  to view this content.

No it doesn't work because I am using the "If" part to tell it which equation to use based on which cell is blank. Thanks for the help though, i'm closer than before.

But both cases divide by column I which is causing the problem so it wouldn't work anyway?

No the first one is multiplied by I. The way the code works is that if the F cell is blank, it will use the first formula to calculate E, and if the E cell is blank, it will use a different formula to calculate F.

Is there a way I could maybe combine two IF functions, so that it would look something like this:

Please Login or Register  to view this content.

Sorry, should really put my eyes in. What about this?

Please Login or Register  to view this content.

It works!! Thank you Stephen R...appreciate it.