ExcelBanter - Hiding Rows of Filtered Data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hiding Rows of Filtered Data (https://www.excelbanter.com/excel-discussion-misc-queries/257349-hiding-rows-filtered-data.html)

JMay

Hiding Rows of Filtered Data

Using xl2007 here.. I have set an Autofilter on my data A3:J350 (Row 3 is
Header)
Rows 4 thru 243 are hidden AND Must REMAIN Hidden, but when I select a
single choice front he AF drow-down (turn off Select all, and choose only
one) the single choice is filtered BUT the Rows 4-243 are Now Visible. How
can I over come this programatically?

All times are GMT +1. The time now is 12:12 AM.