All,

Hoping that someone can help me with this... (mth = revenue amount for that
month)

here is formula used to calculate constant currency for the quarter
=(Mth1*CRate Mth1/PRate Mth1)+(Mth2*CRate Mth2/PRate Mth2)+(Mth3*CRate
Mth3/Rate Mth3)

I would like to use VBA to calculate the results for Q1 to Q4...QTD, BOY,
and YTD (changes based on current month) and return the excel worksheet thus
saving me 72+ columns of information

does any one know how I can use arrays to hould the values and return them
to the work sheet...

I'm really look at how conceptually I would get started with this

Thanks
--
Helping Is always a good thing