Another reason for the Sort and Filter icon to be disabled. Some one please revert with the solution. Multiple sheets are selected the most likely reason why the Sort and Filter icon is grayed out. 1st time when I am running the macro the first row in the visible filtered data is starting at Cell address A4 and next time when I will run the macro it may be A6ģ) The Code is also selecting the 1st row which is a header row. I need this to select the the data only till the last used row in the given range.Ģ) It is not possible to provide the address of the first row after we apply the filter since the first row address may change depending on the values in the table.Į.g. 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: I went to PivotTable Options / Display and the 'Show Items with No Data on Rows and Columns' are both grayed out. 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!! If I filter my row to a certain product that does not have data in all columns (months) the calculations outside the table to not work. I am looking for the code to select the visible data after applying a data filter.
0 Comments
Leave a Reply. |