Printing slected items after using autofilter

[robertguy]

Hi can any please help me ?


What I’m trying to do is to automate printing a shopping list via
button and macro (code sorted for this ) printing a selected range fro
my worksheet.

What I have done is set an auto filter of the items I require and wha
I want to do is to print the selected records, however this list ca
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


Ro

+-------------------------------------------------------------------
|Filename: shopping list.bmp
|Download: http://www.excelforum.com/attachment.php?postid=3864
+-------------------------------------------------------------------

 

[Jonathan Cooper]

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.