VBA
User Func: Next3rdFriday Special case of
smrNextNthWeekday. This one returns the next 3rd Friday after
a given date. Good for calculating the next Options
Expiration Date.
2001.06.01 Rasey
VBA:
CopyFromRecordset Example A working example of how to
quickly download a DAO Recordset from Access into an Excel
worksheet. This is fast and the way to go.
VBA User Func: USFedTax:
An example of how a user function can be a better choice that a huge
nested IF statement.
VBA User
Func: smrIsVisible01: This function will return
a 0 if the row of the Upper Left Cell of varRef is
hidden. 'Other wise it returns a 1
2001.04.09 Rasey
VBA
Sub: smrLabelBubblesAC:
Attach labels to points or bubbles in the active chart that are formulas
that reference the corresponding cells in the Ticker range. Each
point will have as its label the formula: "=TickerSheet!$A$13"
where "TickerSheet" is determined from a passed argument
