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