"For" Commands for worksheets

[Eoshap]

Hi All
Basically I have a spreadsheet that works out and scores companies on their Year to Year Finiacials. Now I would like to add another (Worksheets) year to this existing spreadsheet. The code reads:
For j = 1 To 2
at the moment for it to run some functions on worksheets 1 (year1) and 2 (year2).

My Problem: beucase I like to have year3 to be added to the equation, in the Project Explorer Year3 is Sheet9. How do I make so it'll read Sheet9 aswell?

Please Login or Register  to view this content.

I think I covered everything. Hope to hear from you soon.
Regards
Keung

[Eoshap]

Here are the files in cause you like to see. 2year original works

3year is where it needs working on

Note: CDT file has to be place in the same directory

Regards
Keung

[Palmetto]

Eoshap

Your post does not comply with the Forum Rules you agreed to follow. Per Rule #3, all VBA code must be wrapped in code tags. Please edit your prior post to add the tags, after which possible solutions will be suggested.

Rule #3

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button. For more information about these and other tags, click here.