Posted to microsoft.public.excel.misc

external usenet poster

Posts: 107

Print Button with Criteria

I have a tab in my workbook that I want to print with a print button.
However, it needs to print depending on certain criteria. Such as, if Cell
E6 = "SMB" then print A1:P39, if Cell E6 = "KRT" then print A1:R39, if Cell
E6 = "BRS" then print A1:T39. Is it possible to do this?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
print button macro & specific tabs to print	Chuck[_3_]	Excel Worksheet Functions	2	November 22nd 07 12:21 AM
Print button	[email protected]	Excel Discussion (Misc queries)	1	August 18th 06 11:40 AM
print button	Caveman	Excel Discussion (Misc queries)	2	November 18th 05 12:44 PM
print button	C A	Excel Discussion (Misc queries)	1	June 25th 05 12:24 AM
button to print	rob	New Users to Excel	2	January 13th 05 09:45 PM

All times are GMT +1. The time now is 11:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us