Hello,
i tried searching for an answer to this but couldn't find one. If it's already covered i appologize for my ignorance.
I'm using the Offset function to move through my cells:
EXAMPLE: ActiveCell.Offset([-1], [0]).Select
This will move down to the next cell in my spreadsheet.
If i use a filter, would it be possible to only offset to the next VISIBLE cell? - thereby saving a considerable amount of time...
Best wishes
Christian
i tried searching for an answer to this but couldn't find one. If it's already covered i appologize for my ignorance.
I'm using the Offset function to move through my cells:
EXAMPLE: ActiveCell.Offset([-1], [0]).Select
This will move down to the next cell in my spreadsheet.
If i use a filter, would it be possible to only offset to the next VISIBLE cell? - thereby saving a considerable amount of time...
Best wishes
Christian