View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default 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?