same than end(xldown) but stops on hidden cells if not empty
Hi,
In the first place I thought that end() would stop put the selection on:
- the last contiguous non empty cell (if the current selection and the next
cell in the specified direction are non empty cells)
or
- the first non empty cell (if the current selection is an empty cell or if
the next cell in the specified direction is empty)
no matter what the cells in the between are hidden (hidden row or column).
In fact if some non empty cells in the specified direction are hidden, the
selection won't stop on them.
Is there and built-in function that stops the selection even on non empty
hidden cells?
Did you get my point?
Thx
|