Thursday 22 August 2013

Capture the value of multiple cell range in a custom formulaarray

Capture the value of multiple cell range in a custom formulaarray

I've written my own function in VBA to do some things. Parameters are
Variant.
Private Function ProcessedValuesEx(pValues As Variant)
The problem occurs when I select a multiple cell range as my function
parameter.
When it executes, the parameter has no value. I'm not able to see any
content. Even with the VBA inspector.
When selection only one cell there is no problem. The parameter gets the
content of the cell.

No comments:

Post a Comment