I don't know why I keep forgetting this: if you want to use a VBA function in a worksheet formula, the function must be defined in a module (neither workbook nor worksheet functions are visible).
... until the collector arrives ...
This "blog" is really just a scratchpad of mine. There is not much of general interest here. Most of the content is scribbled down "live" as I discover things I want to remember. I rarely go back to correct mistakes in older entries. You have been warned :)
Blog Archive
-
▼
2007
(94)
-
▼
Jan 2007
(14)
- BIRT vs Script Extensions vs jTDS vs Eclipse Plug-ins
- Excel User-defined Worksheet Functions
- Building esi.execute
- Eclipse xdoclet Error
- SQL Server 2000 vs. Hibernate 3
- Hibernate Logging
- JDK Logging
- Eclipse Applications and JConsole
- log4j Logging
- Hibernate 3.1.3 Failed Saves
- Eclipse Java Compiler Bug
- Eclipse Java Compiler Non-Null Warnings
- Hibernate vs. Object.equals()
- IE7 vs. Automatic Windows Authentication
-
▼
Jan 2007
(14)