Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
same than end(xldown) but stops on hidden cells if not empty
Hi,
In the first place I thought that end() would 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 if the cells in the between are hidden or not (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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
same than end(xldown) but stops on hidden cells if not empty
It appears that if you want it to stop on any of those hidden cells, you will
have to make them visible. Everything I checked in Microsoft help and on the web was silent on the hidden cells, but it makes sense that hidden cells would be ignored since you would not be able to see what was selected. "Fil" wrote: Hi, In the first place I thought that end() would 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 if the cells in the between are hidden or not (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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use xldown to select a range of cells | Excel Discussion (Misc queries) | |||
drag data vertically over hidden cells.. ignore hidden cells | Excel Discussion (Misc queries) | |||
Hi-Lite "empty" unlocked cells in non-hidden rows | Excel Programming | |||
xlDown stops at next empty cell, not at last row of data | Excel Programming | |||
How can I remove hidden empty text cells from Excel? | Excel Worksheet Functions |