I just posted some observations in a reply to Tom.

Apparently if the visibility of rows is "mixed" the delete method will
get "sly", but if all rows are invisible it will delete the invisible
rows.. Never knew that... and i find it very dangerous.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Peter T wrote :

Hi KeepITcool

Do you know more of these "sly" interpretations?

Not sure about "sly interpretations" but Excel appears to treat only
the visible cells in a filtered range as a range, ignoring hidden
rows. Similar to Tom's delete method are Copy & Format, if you follow
what I mean. This contrasts with rows hidden in the normal way.

As you say, the VBA range object returns the entire range, clearly
different to the filtered range Excel works with. I think it's
contigious - even if it's not!

I'd love to get that Excel range, without using selectspecial visible
cells.

Regards,
Peter T