Google Answers Logo
View Question
Q: Excel VBA simple subroutines ( No Answer,   0 Comments )
Subject: Excel VBA simple subroutines
Category: Computers > Programming
Asked by: umfana-ga
List Price: $20.00
Posted: 03 Oct 2006 13:06 PDT
Expires: 04 Oct 2006 10:02 PDT
Question ID: 770534
A friend and I are learning how to do simple VBA subroutines in the
hope that we can develop the knowledge to help us in our stocks
portfolio management. We're a bit stuck (we each get diff answers)with
the following three subroutines. I understand that there are usually
at least 2 methods to a solution but I will be happy with one solution
to each subroutine. I am meeting him in 72 hours so would only like
this answered if it can be done so in the next two or three days.
People who are fluent in Excel VBA tend to be able to write each of
these routines / functions in five or ten minutes.
Here are the ones we are struggling to write:

1. A subroutine that generates the Fabonacci sequence of numbers (the
first n numbers, where n is an integer number that the user inputs).
For example, the first seven numbers will be 0,1,1,2,3,5,8,..

2. a subroutine that generates Pascal?s triangle (the first n rows,
where n is an integer number that the user inputs). For example, the
first three rows will be:  1, 1 1, 1 2 1, ?

3. a function that calculates the number of business days between two
given dates. The user inputs the two dates, upon which the number of
business days are returned.

Clarification of Question by umfana-ga on 04 Oct 2006 07:14 PDT
I see no-one has attempted my question and think think I have solved
the 1st and 3rd one so would now be happy to pay $20 just for a neat
answer for number 2, provided it can be done before my meeting in 48
hours. any takers?
There is no answer at this time.

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy