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?