View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rominall Rominall is offline
external usenet poster
 
Posts: 36
Default Basic question....syntax on active cells from a filter

If I filter and then want to select only those cells showing and give them a
range name, what's the syntax? I tried xllastrow but that gives everything.
I also tried putting something like ...for every activecell in range but that
also gave me everything.

Is this possible or am I wishing too hard?