Sir Babydum GBE
07-14-2005, 08:07 AM
Hi
I'm creating a very sexy little worksheet and I would like some advice please.
I simply need to know 1) how to move down 1 cell on a filtered list. Because if I use my down-arrow or return keys to navigate manually, the next visible cell is selected. But a macro seems just to select the next cel - regrdless of wher it is hidden in the filter or not.
And 2) How do I say in code language;
Check whether the cell I've just landed on is merged, and if it is not - perform this action. But if it is, skip this cell and try the next, and so on. Finally, if after skipping so many cells the macro gets to myRow number, then display a warning "Run out of options" and quit the code.
Suggestions will be much appreciated.
babydum
I'm creating a very sexy little worksheet and I would like some advice please.
I simply need to know 1) how to move down 1 cell on a filtered list. Because if I use my down-arrow or return keys to navigate manually, the next visible cell is selected. But a macro seems just to select the next cel - regrdless of wher it is hidden in the filter or not.
And 2) How do I say in code language;
Check whether the cell I've just landed on is merged, and if it is not - perform this action. But if it is, skip this cell and try the next, and so on. Finally, if after skipping so many cells the macro gets to myRow number, then display a warning "Run out of options" and quit the code.
Suggestions will be much appreciated.
babydum