Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code for selecting worksheet | Excel Discussion (Misc queries) | |||
VBA Code for selecting row | Excel Discussion (Misc queries) | |||
selecting days of week using a formula in spreadsheets | Excel Worksheet Functions | |||
Selecting cells for code | Excel Programming | |||
Selecting a PivotItem in code | Excel Programming |