RE: $$Excel-Macros$$ vba beginner question: manipulating array data

2011-06-19 Thread Daniel
: MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ vba beginner question: manipulating array data I'm just beginning to learn VBA (have experience with Ruby and PHP) and I'm wondering how you would go about doing the following: I have paired data in 2 columns - daily historical stock data w

$$Excel-Macros$$ vba beginner question: manipulating array data

2011-06-18 Thread eggman2001
I'm just beginning to learn VBA (have experience with Ruby and PHP) and I'm wondering how you would go about doing the following: I have paired data in 2 columns - daily historical stock data with the date in column A and the closing value in column B, and assume I have 10 years worth of data. I'd