Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Printing slected items after using autofilter
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 |
#2
|
|||
|
|||
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 Im 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using AutoFilter with worksheet protection in 2000 vs. 2003 | Excel Discussion (Misc queries) | |||
Printing Recto/Verso | Excel Discussion (Misc queries) | |||
Excel AutoFilter Problem | Excel Discussion (Misc queries) | |||
problem printing to PDF | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |