Hi, I need to get the contents of the currently selected range of cells and pass it to the XLL. I've been doing xlCoerce from xltypeRef to xltypeMulti to convert the entire range to an internal structure that can be further processed by the XLL. However, if the AutoFilter is enabled, and some cells are invisible, xlCoerce still works as if these cells were visible - that is, it doesn't "understand" the filtering. The question is: how to get the contents of the currently selected VISIBLE cells? Is there a way to determine whether a cell is visible (i.e. not filtered out) using the C API? Any workarounds? Thanks, Antony
