I have a table, with headers, that has set filters. Once the filters are what I need them to be (outside of the macro), I want to copy the data showing to another tab. Without the filters, I'd want columns A through G, rows 2 through the last with content but, with the filters, I can't predict what the top row will be. What language do I need to use to effectively select A1 and then arrow down one row to define the top cell?
Thanks!
Thanks!