I am using the End xldown command to activate a range. I first search for text in a cell, the header, and then offset down one row to get to the first cell in the range I want to activate. My problem arises in situations where there is only one row under the header that I want to activate. How do I use or workaround the End xldown command when there is only one row below, but I still want to select that row?
Thanks
Start Free Trial