Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
works fine if the filter is set to show all data.
Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Select
but that just returns an application or object defined error
. That, however, selects all cells EXCEPT for the filtered cells
Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).SpecialCells(xlCellTypeVisible).Select
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.