Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Selecting the next *visible* cell (https://www.askmehelpdesk.com/showthread.php?t=834483)

  • Sep 19, 2017, 09:09 PM
    Andante
    Selecting the next *visible* cell
    OFFSET is great for selecting any new location from the current cell. But if that new location happens to be hidden, OFFSET doesn't care.

    How can I select a certain range away from the current cell, counting *visible* cells only?

    • All times are GMT -7. The time now is 11:08 PM.