Printing slected items after using autofilter

I'm not clear on part of what you wrote, but if you leave your print range
blank, and then autofilter your list, Excel will only print what is visable.

"robertguy" wrote:

>
> Hi can any please help me ?
>
>
> What I’m trying to do is to automate printing a shopping list via a
> button and macro (code sorted for this ) printing a selected range from
> my worksheet.
>
> What I have done is set an auto filter of the items I require and what
> I want to do is to print the selected records, however this list can
> get bigger or smaller dependant on the number of items selected.
>
> Any thoughts would be very much appreciated (Excel version 2000)
>
> Please see attached bitmap
>
>
> Many Thanks
>
>
> Rob
>
>
> +-------------------------------------------------------------------+
> |Filename: shopping list.bmp |
> |Download: http://www.excelforum.com/attachment.php?postid=3864 |
> +-------------------------------------------------------------------+
>
> --
> robertguy
>
> 44 Married two kids
> ------------------------------------------------------------------------
> robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963
> View this thread: http://www.excelforum.com/showthread...hreadid=471727
>
>