Filter doesn't filter range?

Hello,

Why after these lines does VBA apply the filter to all the rows on my spread sheet when all I ask is to apply the filter to only the A6-A10 range?

Please Login or Register  to view this content.

All help appreciated

Thanks
RN

This can be prevented if you have row 11 as blank.

Originally Posted by mrice

This can be prevented if you have row 11 as blank.

But A11 is not part of the requested range????

And in any case A11 cannot be blank...