User Stevens, Doug E ( posted:


The reason the function does not work on a virtual object is because the
function has to be able to communicate with the object. Since the object is
"virtual" (i.e. doesn't really exist), it can't do that. I have had similar
experience with Excel. What I ended up doing was:

1. Create the virtual table.
2. Use the valid virtual table functions to navigate through the table.
3. Capture the displayed value in the formula bar.