Trying to Repeat an If, Than, ElseIf code

[KAGM]

I'm new to writing macro code and I'm trying to repeat an If, Than, ElseIf code over multiple rows.

Part of the code I've written is below. The actual code is quite long and goes through multiple variables on the same two columns (E & F). The rows I'm trying to repeat them on are 11-75. Any help would be appreciated as I can't seem to figure this one quite out.

Please Login or Register  to view this content.

Moderators note: code tags added for you - this time

[FDibbins]

Hi and welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[Norie]

Perhaps you could use Select Case.

Please Login or Register  to view this content.

[KAGM]

Sorry about that. Thanks for fixing the code tags for me.

[KAGM]

Thanks for the response Norie.
Because I'm running multiple calculations (3 calculation for each province and territory) the If, Than, ElseIf seems to work the best.

From what I've discovered I need to create a loop, but I don't know of the right kind of loop that will run the same code each row (11 - 75). I've included two provinces so you can see better what I'm trying to do.

Please Login or Register  to view this content.

[Norie]

Sorry, how would Select Case not work?

Did you try the code I posted?

PS I would actually suggest nested selected casses, with the outer one being for each province/territory.

Please Login or Register  to view this content.

[KAGM]

Yes, I did try the first code you posted... I'm going to try the second one right now and I'll get back to you.

PS I do like the way Select Case looks.

[KAGM]

GFE Expense Report macro testing.xlsm

I've been working with the second code you posted, while it works well on the first row (11) it comes up with the run-time error:5 when I try to run the macro without info in the first (row 11). If I have info on more than one row (say row 11&12) it only runs on row 11. I've attached the work book so you can see what it looks like. Thanks for any and all help on this.

[Yraen]

Try this, be warned it's untested but it should do what you want.

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.