View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Humphrey Humphrey is offline
external usenet poster
 
Posts: 22
Default Create Range of Visible Rows only

I would like to create a range containing only the visible rows in columns
A:N. I can filter the list and then create a range but it selects all the
hidden rows as well. Is there a way to restrict the range to just the
visible rows?

H