Please can you help with the two command buttons in the attached.
Depend on which is pressed, I'd like the code to search along the columns and find the next month.
Line 2 the current month is in E2 "01/03/2012" if I click "Plus" or command button two, I would like the code to recognise and then jump to selection to AA2 "01/03/2012" and so on until the end of the range.
I would like command button 1 to do the same but in reverse. gary3.xls
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …