Need Tutoring help with array and 1 for loop problem.

Create a module that will do the following:
Set Option Base to 1 (I googled how to do this and I get the general idea of what it means.)
Create an array to handle the Months of the year (use a variant data type and assign the value to the array manually in the code using the Array function)

Please Login or Register  to view this content.

Create a second array to show total days in each month (again use a variant data type and assign manually using Array function) I think it's the same as above but days instead? I just don't know if it means write out everyday for the whole month.
Call a procedure to output the data to the spreadsheet ( I have no clue how to call a procedure, I think it has to do with writing different procedures and using call function but I don't know how to do that)
Inside the new procedure, use a 1 For loop to output the Months across the top of the spreadsheet and the days of the month on the next line below (make sure they correspond) Cross this bridge as we get there.

Any help is appreciated. Cheers!

home work?
Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

In a classroom setting, designed to provide the platform for asking anything, your teacher should be making it easy on you to ask, and re-ask, any questions you need. There's nothing irrelevant about honestly trying to grasp new concepts. More often than not, a pupil simply needs more and more "examples" of the concept, each one making it clearer and clearer to the eye what you're seeing. Repetition is your friend.

Your first example is correct. Once you've filled your array Months with your 12 entries, those will now be located in positions 0-11 of the array, not 1-12 like we would think. The array is zero-based, so the count starts at zero.

You can thus refer to January as Months(0), and December is Months(11).

Please Login or Register  to view this content.

-------------
Create a second array showing the total days in each month
This would also be an array with 12 elements in it, however the value in each element would be the number of days for each of the months listed in the original array.

So if you wanted to list the Days in January, that's 31, right? So what would the array declaration and code look like, using your existing Months example, to create a second array of 12 answers called Days?

-------------------
Call A Procedure

You have the idea, it sounds. A macro can be any length, so it is common to write a short macro (subroutine) to accomplish a specific task, then "Call" that macro by name as needed. A generic example:

Please Login or Register  to view this content.

Now that can be called at anytime from another macro by simply using it's name:

Please Login or Register  to view this content.

Each of those subroutines above would be executed in the order they are called.

-------------
For/Next Loops
Can you give us examples showing your current understanding of FOR/NEXT loops?

@ Jerry

if he is using OPtion Base 1 (like he mentions in post #1), wouldn't that be positions 1-12 in the Month array?

I could be confused

Nope, you're absolutely right. Missed that completely. So the element positions will be 1-12, much easier on the eye.

no problem....thanks for the verification....

You may find this page helpful;

http://www.homeandlearn.org/excel_vba_and_arrays.html

And yes, an array(a,b) wold be a two dimensional array. e.g dim array(1 to 12, 1 to 2) as variant would define you an array 12 row x 2 column array.

I would recommend you use option explicit (avoids variable declaration issues /typos in variable names) (Tools -> Option -> Editor: Require Variable Declaration)
When debugging things, I am sure you are already aware of break points, but also make sure you have the immediate and locals windows showing (View -> select 'Immediate Window' and 'Locals Window')

Also generally using option base 1 is bad practice; a recipe for chaos on bigger projects, although in this case it designed to try and make your life simple.

So this is what I have so far

Please Login or Register  to view this content.

My get the concept of for/next loops. basically loops through the code and each time adds one to it. but how do i get the code inside the loop. Give me a different hint (not the code) just something that'll help explain the logic behind the code?
Since i'm trying to generate data to the right and down I was thinking perhaps i'd have to use xlRight and xlDown

Thanks for all the help guys. I know it's probably like teaching a toddler. but it's much appreciated

You don't need quotes around the numbers in your DAYS array, they are numbers, not text. Text is put in quotes.

Why would you need to count from 1-31 in January? The assignment stated the goal was to list the Months in one row, and the total number of days in each month in the next row down.

Please Login or Register  to view this content.

So you only need the two arrays and a way to LOOP through the 12 elements of each, inserting the values from MONTHS into row1 and DAYS into row2.

You declared your arrays in one sub, then ran the "loop" in a completely separate sub. Put the loop up into the first sub so the scope of the arrays can be seen by the loop. Then your second macro is merely a "call" of the first calendar sub.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.