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.
