Posted 2 March 2023, 12:44 am EST
Hello,
I used
Columns[0, 9].AllowAutoFilter = true
to filter my grid.when I use
sheet.GetSelections
I retrieve all the selected rows (those displayed by the filter and those hidden but which are in my selection). How recovering only the lines actually visible on the screen.ex after filtering
- row1 : displayed
- row2 : displayed
- row3 : hidden
- row4 : hidden
- row5 : displayed
- row6 : displayed
If I selected row1 to 5, I retrieve row 1 to 5 then 3 and 4 are hidden.
thks