Excel Tips (Nov. 2004)
- Returning Excel Error Values from VBA User Defined Functions.
- Public Function varMyFunction(args) as variant
.....
'return the value on an error condition:
varMyFunction = CVErr(xlErrNA)
'Excel constansts for Error values are
'xlErrNA, xlErrNum, xlErrRef, xlErrValue
-
- Digital Certificates and
Trusted Sources for Running Excel Macros under High Macro Security
- Excel VBA: How to retrieve the Range Name of the Active Cell?
- Access: How to put the current record at the top of a continuous
form?
- Access: linking to two tables in different databases (under different security)
3-Sept-2004 .access.tablesdbdesign
- Ctrl-Enter, Ctrl-Shift-Enter:
-
Writing Your First VBA Function in Excel - ExcelTip.com
- Using Folder API to manage Backend
database File connections:
- PrintSetup on selected Sheet Group [Tom Ogilvy 8/27/2004]
- Copy Excel Chart as a Picture
- Google search engine add-in
by Ron de Bruin saves me a lot of time looking up (VBA) in books
[David Adamson - 8/25/2004]
- Get Intersection of ranges using labels
- Apply Proper Case to a range of cells:
- Copy only Formulas to a new sheet
- Count Records by Date. Don't count
duplicate records.
-
|
