Results 1 to 21 of 21

Need Tutoring help with array and 1 for loop problem.

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2014
    Location
    Iowa
    MS-Off Ver
    2013
    Posts
    19

    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)
    Dim months  as Variant
    Months= Array("January", "February", "March", "April", "May", "June", "July", "August","September", "October", "November", "December")
    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!
    Last edited by sean089; 10-30-2014 at 12:34 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Loops and arrays
    By LadyB in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-12-2013, 04:28 PM
  2. Need help with loops and arrays in VBA Macro
    By lealea1982 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 08-26-2011, 08:51 AM
  3. VBA Loops + Arrays
    By Kengh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-26-2010, 07:41 PM
  4. Loops and Arrays
    By v2jtb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-29-2010, 12:09 PM
  5. VBA excel using arrays and loops
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2006, 08:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1