![]() ![]() ![]() Range("A:p").SpecialCells(xlCellTypeVisible).Selectġ) after applying the filter, while selecting the data it is selecting all the rows in given range till last row on the workbook. I am using below code to Select the Visible rows in the target range: Actually I know how to select the data after applying the data filter but the issue is I am not able to exclude the header row and give the target range as used (non-blank) rows only!! I am looking for the code to select the visible data after applying a data filter.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |