[ VBA Functions ] [ VBA Subroutines ] [ VBA Code by Topic ] [ Visual Studio Tools for Office Links ] [ Key Reference Document Links ] [ PowerPoint ]
Houston Excel SIG VBA Subroutine Examples - Listed in Reverse Chronological Order
VBA Example using Arrays and
a method of transferring data directly from an Excel Range to a Variant Array
Problem: square array K (NxN). Vector range. V(1xN) or V(Nx1)
Copy to KRed only the elements in K(i,j) where V(i) or V(j) = 0.
Alan Beban modified to show how to go directly from a range variable to an
undimensioned variant containing the array.
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
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.
