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
|Link Excel Spreadsheet to Access, not using Transferspreadsheet||5||29|
|Excel VBA - merge "specific" data from workbook in to "new" workbook.||19||22|
|Input Data Using a unique ID from another sheet in Excel||3||5|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!