VBA Code for selecting days
 

Hi,

Im strugling with this whole VBA code which I'm slowly trying to
learn.

Heres what I wish to do

I have daily dates from 1-Jan-94 all the way to 31-Dec-03 in column A
(starting in row 5)

In column C, I have the daily share prices (also starting in row 5)

In column F, I wish to work out the average returns of the last 5 days
of each month i.e =average(x:x) where x=the share prices for the last 5
days of Jan, feb and so on.

I hope my explanation is clear.

I am trying to do all this in VBA Code and my worksheet name is called
"Results"

Can anyone help me out?

Cheers
Rob


---
Message posted from http://www.ExcelForum.com/