Hi,
Try the visible cells instead:
debug.print
ActiveSheet.AutoFilter.Range.SpecialCells(xlCellTy peVisible).Address
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Rominall" wrote:

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?